Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Revoke CREATE SESSION Privilege from a User
How To Revoke CREATE SESSION Privilege from a User? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
✍: FYIcenter.com
If you take away the CREATE SESSION privilege from a user, you can use the REVOKE command as shown in the following example script:
>.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter SQL> REVOKE CREATE SESSION FROM dev; Revoke succeeded. SQL> GRANT CREATE SESSION TO dev; Grant succeeded.
This script restored the CREATE SESSION privilege to user "dev", so you can continue other example scripts below.
2007-05-01, 4829👍, 0💬
Popular Posts:
If cookies are not enabled at browser end does form Authentication work? No, it does not work.
What is the method to customize columns in DataGrid? Use the template column.
How can method defined in multiple base classes with same name be invoked from derived class simulta...
Can we have shared events ? Yes, you can have shared event’s note only shared methods can raise shar...
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...