| Creating default roles [message #341687] |
Tue, 19 August 2008 23:58  |
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
|
Senior Member |
|
|
Hi all,
Today while checking database, i came accorss the point that there are only two dba roles in database.
SQL>select * from dba_roles;
ROLE |PASSWORD
------------------------------|--------
CONNECT |NO
RESOURCE |NO
I have created one user specifically for full database export. But in database no other roles are there(not even the EXP_FULL_DATABASE role).
Please tell me, is there any utility or way to create all missing default roles in database?
|
|
|
|
|
|
| Re: Creating default roles [message #341693 is a reply to message #341689] |
Wed, 20 August 2008 00:23  |
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
|
Senior Member |
|
|
I know, I can create roles using "create role" statements, using notepad and/or sqlplus.
But EXP_FULL_DATABASE, DBA, IMP_FULL_DATABASE, SELECT_CATALOG_ROLE, RECOVERY_CATALOG_OWNER, GATHER_SYSTEM_STATISTICS etc are not simple roles, right? These roles contains authority for adminstration related work. How can i creat them..?
Dear anacedent,
You are one of the respected seniors of our fourms. I hadn't not expecting this kind of answers from you dear.
Regards,
Dipali..
|
|
|
|
|
|
|
|
| Re: Creating default roles [message #341709 is a reply to message #341707] |
Wed, 20 August 2008 01:33 |
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
|
Senior Member |
|
|
Thanks Ana and Michel,
From other 9i database (working properly), i got the list of all the missing roles and all the privilages assigned to those roles. I have created script to create those roles and grant priviledges to them (create role and grant statements).
Is it okay if i run that script as a SYS user to create missing roles and assign associated priviladges to them? Will this damage my database?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
