Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> user privileges
rokyj055
post Jan 24 2012, 04:28 AM
Post #1


Advanced Member
***

Group: Members
Posts: 75
Joined: 23-January 12
Member No.: 46,637



Dear All,

I have created a user "user1" who has dba role.

i wanted to create a another user "user2" with same privileges which user1 has.

so i granted dba role to user2 but i dont want user2 to have "drop" privilege on any objects except his own objects.

i dont want to create a trigger in this case.

please help me
Go to the top of the page
 
+Quote Post
burleson
post Jan 24 2012, 05:17 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,603
Joined: 26-January 04
Member No.: 13



Hi Rocky,

>> so i granted dba role to user2 but i dont want user2 to have "drop" privilege on any objects except his own objects.

Bb default, a user can only drop their own objects!

The DBA role is a superuser, I've never tried to revoke anything from it . . .

I have not tried this by see if this works:

CODE
create userx identified by xxx;
grant dba to userx;
revoke drop any table from userx;


Otherwise you will have to name the privileges one-at-a time . . . .

***********************************************************
>>
i dont want user2 to have "drop" privilege on any objects except his own objects.

You could also try this:

CODE
create userx identified by xxx;
grant select any table to userx;
grant update any table to userx;
grant insert any table to userx;


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 20th October 2014 - 05:46 PM