|Granting system privileges
|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;