OraFAQ Forum: Security » User Rights

Home » RDBMS Server » Security » User Rights

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

User Rights [message #147554]

Fri, 18 November 2005 03:41

kpsrinivas
Messages: 4
Registered: November 2005
Location: Hyderabad

Junior Member

A user is created and Dba rights are granted to him. after sometime dba rights are revoked. what rights user will be having now

Report message to a moderator

Re: User Rights [message #147575 is a reply to message #147554]

Fri, 18 November 2005 04:45

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Quick answer- none. I'm sure there is more to that question however.
Jim

Report message to a moderator

Re: User Rights [message #147582 is a reply to message #147575]

Fri, 18 November 2005 06:08

kpsrinivas
Messages: 4
Registered: November 2005
Location: Hyderabad

Junior Member

New user is created and default tablespace is alloted. user has granted connect resource. Later DBA rights are granted to that user. After sometime DBA rights are revoked. then what rights will be having that user

Report message to a moderator

Re: User Rights [message #147583 is a reply to message #147582]

Fri, 18 November 2005 06:19

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Then he will have the rights granted under the connect and resource roles. Have you thought of testing this yourself, or reading up on privs and roles in the documentation? (you can get the documentation from http://tahiti.oracle.com)

Jim

Report message to a moderator

Re: User Rights [message #147608 is a reply to message #147554]

Fri, 18 November 2005 09:11

ramsat
Messages: 49
Registered: November 2005

Member

Hai man check out this

SQL> select * from dba_role_privs where grantee ='RAMESH';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
RAMESH CONNECT NO YES
RAMESH RESOURCE NO YES

SQL> grant dba to ramesh;

Grant succeeded.

SQL> select * from dba_role_privs where grantee ='RAMESH';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
RAMESH DBA NO YES
RAMESH CONNECT NO YES
RAMESH RESOURCE NO YES

SQL> revoke dba from ramesh;

Revoke succeeded.

SQL> select * from dba_role_privs where grantee ='RAMESH';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
RAMESH CONNECT NO YES
RAMESH RESOURCE NO YES

hit me if u have any doubts in my mailid

Report message to a moderator

Previous Topic:	schema which only selects tables
Next Topic:	Issue in setting listener password

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 03:48:27 CST 2025