OraFAQ Forum: Security » ORA-01919: role 'XDBADMIN' does not exist

Home » RDBMS Server » Security » ORA-01919: role 'XDBADMIN' does not exist

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01919: role 'XDBADMIN' does not exist [message #154405]

Sun, 08 January 2006 01:07

n_srinath4u
Messages: 3
Registered: January 2006

Junior Member

Hi,

I have used the following code for creating user and granting role to that user. But i am getting error while granting role as
ORA-01919: role 'XDBADMIN' does not exist!!..
Please let me know where i went wrong...

create user xDemo identified by demo
default tablespace users
temporary tablespace temp
quota unlimited on users;

grant create session,
alter session,
create table,
create trigger,
create type,
create any directory,
drop any directory,
xdbadmin
to xDemo;

thanks,

Srinath N

Report message to a moderator

Re: ORA-01919: role 'XDBADMIN' does not exist [message #154427 is a reply to message #154405]

Sun, 08 January 2006 05:39

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Quote:

create any directory,
drop any directory,
xdbadmin
to xDemo;

The error is self explanatory. You are trying to grant a role
XDBADMIN and its not present is your database so the error is obvious.

You can verify the same using the following query.

select role from dba_roles
        where role like 'XDB%';

Note: Log in as sys to run the above query.

Report message to a moderator

Re: ORA-01919: role 'XDBADMIN' does not exist [message #154429 is a reply to message #154427]

Sun, 08 January 2006 06:26

n_srinath4u
Messages: 3
Registered: January 2006

Junior Member

Yeah I observed that the role is not there in database. But I want to give privileges for creating directories in xml DB engine. I referred http://www.oracle.com/technology/pub/articles/williams_xmldotnet.html for make use of xdbadmin, in that they have specified it as create role ..., xdbadmin. Then how could i create this

Report message to a moderator

Re: ORA-01919: role 'XDBADMIN' does not exist [message #155378 is a reply to message #154429]

Sun, 15 January 2006 13:12

n_srinath4u
Messages: 3
Registered: January 2006

Junior Member

ThanQ I got it. I am using Oracle9i release 1 which does't support XML DB. I've installed 10g then it worked and i think it also work for oracle9i release 2.

Srinath N.

Report message to a moderator

Previous Topic:	set Expiry Date of user password
Next Topic:	Public DBA role

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 20:23:37 CST 2025