Help - Search - Members - Calendar
Full Version: user privileges
Oracle DBA Forums > Oracle > Oracle Forum
rokyj055
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
burleson
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;
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.