469,167 Members | 1,976 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

about system privileges

13
What is the purpose of giving grant dba,connect,resource to some user....

What is this actually do?

if i give this, is it necessary to grant select update privileges to that user or no need.....

and one more....how to revoke dba,connect and resource privileges from that user...

Kindly help...thanks
Jul 5 '07 #1
4 1483
debasisdas
8,127 Expert 4TB
connect means the user can connect to the database ,u can also grant create session for the same purpose.

resource means the user has previlege on the default tablespace .So the user can create his own objects like tables ,views etc...

if you grant dba the user gets previleges on some of the data dictionaries , on which normal user does not have any previleges.

grant select ,insert ,update is different from the previous grant . these are object previleges ,means these are granted on specified objects . And only the owner of the object or any other user who have required previleges on those objects can grant these to others.
Jul 5 '07 #2
kalps
13
connect means the user can connect to the database ,u can also grant create session for the same purpose.

resource means the user has previlege on the default tablespace .So the user can create his own objects like tables ,views etc...

if you grant dba the user gets previleges on some of the data dictionaries , on which normal user does not have any previleges.

grant select ,insert ,update is different from the previous grant . these are object previleges ,means these are granted on specified objects . And only the owner of the object or any other user who have required previleges on those objects can grant these to others.
thanks..but how to revoke those system privileges after it has been granted
Jul 5 '07 #3
Hi

revoke <1st priv>, <2nd priv> on <objectname> from <username>;

Hope this helps
Jul 27 '07 #4
debasisdas
8,127 Expert 4TB
to revoke the system previleges do not use object name as it is not on a object.

for ex
=========
Expand|Select|Wrap|Line Numbers
  1. REVOKE CONNECT FROM SCOTT;
Jul 28 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Perttu Pulkkinen | last post: by
4 posts views Thread by Amardeep Verma | last post: by
1 post views Thread by tabai | last post: by
2 posts views Thread by fReDiNi | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.