Describe how to revoke CREATE SESSION privilege from a user

<<Previous  Next>>

Oracle - Describe how to revoke CREATE SESSION privilege from a user - Feb 23, 2010 at 11:00 PM by Rajmeet Ghai

Describe how to revoke CREATE SESSION privilege from a user.

Create session privilege allows user to connect to the database. If it needs to be revoked, following command can be typed:

REVOKE CREATE SESSION FROM user_name

Oracle - Describe how to revoke CREATE SESSION privilege from a user - April 10, 2009 at 11:00 AM

Describe how to revoke CREATE SESSION privilege from a user.  

If a CREATE SESSION privilege has been taken from a user, then REVOKE can be used as follows:

SQL> REVOKE CREATE SESSION FROM dev;
Revoke succeeded.

Also read

Oracle system privilege

A system privilege is the right to perform an action on any schema objects of a particular type.............

Use of Roles in oracle

Roles in Oracle can be used to grant privileges to a specific group of users for security. The database manager is usually responsible for granting privileges to a Role..........

What are the different Levels of Auditing? Explain them

Statement Auditing, Privilege Auditing, and Object Auditing...........

Define Statement Auditing, Privilege Auditing and Object Auditing in oracle.

Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects..............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience