User

From Oracle FAQ
Jump to: navigation, search

The term user can refer to:

  • A user account on the Oracle database that is used to gain access to the database. Use the CREATE USER or GRANT command to create a new database user:
SQL> -- create a scott2 user
SQL> CREATE USER scott2 IDENTIFIED BY tiger2; 

SQL> -- create a scott3 user and grant privs to it
SQL> GRANT connect, resource TO scott3 IDENTIFIED BY tiger3; 
  • A pseudo-column returning a string value with the name of the currently connected user.
SQL> SELECT user FROM dual;
USER
------------------------------
SYS
  • A user account on an application or system that is used by users to gain access to the application's functionality.
  • Those people that hassle us poor techies.

Also see[edit]

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #