Home » RDBMS Server » Security » User Rights
icon7.gif  User Rights [message #147554] Fri, 18 November 2005 03:41 Go to next message
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
Re: User Rights [message #147575 is a reply to message #147554] Fri, 18 November 2005 04:45 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Quick answer- none. I'm sure there is more to that question however.
Jim
icon14.gif  Re: User Rights [message #147582 is a reply to message #147575] Fri, 18 November 2005 06:08 Go to previous messageGo to next message
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
Re: User Rights [message #147583 is a reply to message #147582] Fri, 18 November 2005 06:19 Go to previous messageGo to next message
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
Re: User Rights [message #147608 is a reply to message #147554] Fri, 18 November 2005 09:11 Go to previous message
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

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


Current Time: Fri Mar 29 07:00:58 CDT 2024