Privilleges
Privilleges are of two types in oracle:
  1. System privileges
  2. 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.)
  1. All
  2. alter
  3. delete
  4. execute
  5. index
  6. insert
  7. references
  8. select
  9. 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;

Hosted by www.Geocities.ws

1