Topic : User Management

What is the password you have to set in the init.ora to enable remote login ?


Answer :

Remote_login_password_file=exclusive

Show Answer Discuss

How do you get you demo files get created in your user?


Answer :

/sqlplus/demo/demobld.sql execute this script on which user you want

Show Answer Discuss

What is user Account in Oracle database?


Answer :

An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges.

Show Answer Discuss

How to create a user and grant permission?


Answer :

SQL>create user username identified by password default tablespace users quota unlimited on users;
SQL>grant connect,resource to username;

Show Answer Discuss

How list users who logged into database?


Answer :

SQL>SELECT USERNAME FROM V$SESSION;

Show Answer Discuss