Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
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, 4881👍, 0💬
Popular Posts:
When should the method invokeLater() be used? This method is used to ensure that Swing components ar...
What’s the difference between Unit testing, Assembly testing and Regression testing? Unit testing is...
.NET INTERVIEW QUESTIONS - What are types of compatibility in VB6? There are three possible project ...
What will be printed as the result of the operation below: main() { int x=5; printf("%d,%d,%d\n",x,x. ..
How To Merge Cells in a Column? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells If you ...