Home » RDBMS Server » Security » ORA-01919: role 'XDBADMIN' does not exist
ORA-01919: role 'XDBADMIN' does not exist [message #154405] Sun, 08 January 2006 01:07 Go to next message
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
Re: ORA-01919: role 'XDBADMIN' does not exist [message #154427 is a reply to message #154405] Sun, 08 January 2006 05:39 Go to previous messageGo to next message
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.
Re: ORA-01919: role 'XDBADMIN' does not exist [message #154429 is a reply to message #154427] Sun, 08 January 2006 06:26 Go to previous messageGo to next message
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
Re: ORA-01919: role 'XDBADMIN' does not exist [message #155378 is a reply to message #154429] Sun, 15 January 2006 13:12 Go to previous message
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.
Previous Topic: set Expiry Date of user password
Next Topic: Public DBA role
Goto Forum:
  


Current Time: Thu Mar 28 11:16:12 CDT 2024