|Lesson 4||Granting system privileges|
|Objective||Grant system privileges to a user.|
SQL GRANTcommand controls what privileges a user will have. You can issue the
GRANTcommand 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 OPTIONallows that user to further grant the privileges to other users.
WITH ADMIN OPTIONis described later in this module.
Connect system/ ****@coin
CREATE TABLEprivileges. The highlighted
CONNECTcommand will be replaced by what you type.
GRANTsucceeded, and a message to that effect is displayed in the bottom half of the window.
PUBLIC. For example, the following command gives everyone the
GRANT CREATE TABLE TO PUBLIC;