Lesson 4 | Granting system privileges |
Objective | Grant system privileges to a user. |
SQL GRANT
command controls what privileges a user will have.
You can issue the GRANT
command from SQL*Plus or SQL Developer.
View the code below to see what the syntax looks like.
GRANT privilege[, privilege...] TO username [WITH ADMIN OPTION];
WITH ADMIN OPTION
allows that user to further grant the privileges to other users.
WITH ADMIN OPTION
is described later in this module.Connect system/ ****@coin
CREATE SESSION
and CREATE TABLE
privileges. The highlighted CONNECT
command will be replaced by what you type. GRANT
succeeded, and a message to that effect is displayed in the bottom half of the window. PUBLIC
. For example, the following command gives everyone the CREATE SESSION
privilege:GRANT CREATE TABLE TO PUBLIC;
GRANT
statements.