Privilleges
Privilleges are of two types in oracle:
- System privileges
- Object Privileges
System Privilleges
System privileges are those privileges which can
modify a stored object.
Some Example system privileges are : (create table, drop table, delete any table and so on....)
Grant create table to my_new_user;
Grant alter any table to my_new_user;
Grant drop any user to my_new_user;
Grant grant any privillege to my_new_user;
and many more..
Of all the most important privilege is the grant any privillege which grants all
system privileges to user my_new_user if the system privilege was not previously
assigned to the user.
Object Privilleges
Object privileges are those privileges which are applicable to specific objects
such as ( Tables, views , procedures and so on.)
- All
- alter
- delete
- execute
- index
- insert
- references
- select
- update
Object privileges must be granted to other users in order for them
to select, insert, update, create index or delete the objects.
grant select,insert,update,delete ON my_new_table to my_new_user ;
grant select,insert,update,delete ON my_new_table to public;