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 Grant CREATE SESSION Privilege to a User
How To Grant CREATE SESSION Privilege to a User? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
✍: FYIcenter.com
If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the server:
>.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter SQL> GRANT CREATE SESSION TO dev; Grant succeeded. SQL> disconnect SQL> CONNECT DEV/developer Connected.
2007-05-02, 4686👍, 0💬
Popular Posts:
.NET INTERVIEW QUESTIONS - What is the difference between System exceptions and Application exceptio...
How is the MVC design pattern used in Struts framework? In the MVS design pattern, there 3 component...
Jack developed a program by using a Map container to hold key/value pairs. He wanted to make a chang...
Where are cookies actually stored on the hard disk? This depends on the user's browser and OS. In th...
What Are the Parameter Modes Supported by PL/SQL? - Oracle DBA FAQ - Creating Your Own PL/SQL Proced...