Solved

what role needed

Posted on 2012-03-21
11
533 Views
Last Modified: 2012-03-23
What role a user needs so he can grant system privs to others like

GRANT DROP ANY TABLE
GRANT LOCK ANY TABLE
GRANT GRANT ANY ROLE
GRANT SELECT ANY TABLE


Thanks oracle 11.2.0.3
0
Comment
Question by:Greens8301
11 Comments
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
Dba would do it or imp_full_db. But it would be better to creat your own role
0
 

Author Comment

by:Greens8301
Comment Utility
I think grant grant any privilege to user1 with admin option.

Then user1 can give those grants to others
0
 
LVL 4

Expert Comment

by:VictorTarasov
Comment Utility
grant select_any_dictionary to view dba_role_privs
0
 

Author Comment

by:Greens8301
Comment Utility
I've requested that this question be deleted for the following reason:

Found solution myself
0
 
LVL 31

Expert Comment

by:awking00
Comment Utility
>>Found solution myself<<
Please post the final solution for the knoledge base.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Greens8301
Comment Utility
The final solution is


SQL>grant grant any privilege to user1 with admin option.

Then user1 has the ability to  give those mentioned grants to others
0
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
>>> grant grant any privilege to user1 with admin option.


that will work, but, as with the original suggestion - it's not appropriate
 you should create a role that contains the privileges you want and assign that.

also, the question specifically requested a ROLE,  and that answer is not a role.
0
 

Author Comment

by:Greens8301
Comment Utility
The question was what a user NEED in order  to do those functrions

Weather to assign it with a role which is a good practice or assign straight away is maitenance perspective. But what I needed was how can a user do those functions with what privilege given to him  

The answer is "Grant any privilege with admin option" given to the user
0
 

Author Comment

by:Greens8301
Comment Utility
imp_full_db as suggested by sdstuber might work I have not tested it. But it is bit more exhaustive assignment than to specific needs.
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
Comment Utility
exactly,  that's why I recommended creating your own role.

you asked what which role you could grant, so I suggested two of the default roles.
but the "better" suggestion is to create your own role.


grant any privilege is the most powerful privilege you can give someone and, it's not a role.
0
 

Author Closing Comment

by:Greens8301
Comment Utility
Sorry for the confusion

Thanks for the role speccific solution
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now