Sql Fundementals Ii (Grant, Revoke)

Front 1

there are more than 100 privileges to give (permissions to do something are called privileges in oracle).
INSERT, UPDATE,REMOVE, CREATE SEQUENCE, are all examples.

Back 1

you can also create a standard set of privileges to give to a group of users like (the mangers profile) this is called a ROLE in oracle.

Front 2

create a user with a password

Back 2

CREATE a_user IDENTIFIED BY a_password;
CREATE scott IDENTIFIED BY tiger;

Front 3

Grant a user a privilege.
(note: Unless YOU have the privilege or are the DBA. you cannot grant others privileges. )

Back 3

GRANT create view, create table, create sequence, create session
TO scott;

Front 4

create a role for the managers group

Back 4

CREATE ROLE managers_group;

Front 5

give all the managers access to create a view

Back 5

GRANT create view, create table TO
managers_group;

Front 6

grant a role to users.

Back 6

GRANT managers_role TO amy, chris, scott;

Front 7

Change the password for scott. He forgot his password again.
(you must be a DBA for this)

Back 7

ALTER USER scott IDENTIFIED BY scott_ur_Fired;

Front 8

if you are the owner or creator of an object...(a table, view, sequence) only you may change it unless you grant that privilege to someone else. Grant a privilege to someone.

Back 8

GRANT select, update ON employees_table TO sue, rich;

Front 9

give only scott, sue, chris and the managers the update privilege of specific columns only, of the employee table.

Back 9

GRANT update (department_name, department_id) ON employees_table TO scott, sue, chris, managers_role;

Front 10

give a user the power to grant privileges to others.

Back 10

GRANT select, insert
ON departments TO scott WITH GRANT OPTION;

Front 11

allow all users to query data from alices departments table

Back 11

GRANT select ON alice.departments TO public;

Front 12

use the data dictionary to view privileges given to others.

Back 12

SELECT * FROM user_tab_privs;

Front 13

use the data dictionary to view privileges given to other ROLES

Back 13

SELECT * FROM role_tab_privs;

Front 14

you use the REVOKE statement in the same way you would GRANT an object. Anyone granted privileges by a user/role that was revoked will be revoked as well.

Back 14

cascade restraints.....with grant option