Firstly create a “sample” user with “sample_pass” password;
create user sample identified by sample_pass;
Some commands that grant user on objects and roles;
grant dba to sample; –gives dba role to sample user
grant create database link to sample; –now, user can create db link
grant create table to sample; –user can create table under defined schema
grant drop any table to sample; –grants user to drop table under any schema, there is no “drop table” –option!
grant create procedure to sample; –grants user to create function, package or procedure
If we use, “with admin option” clause at the end of command, this gives grantee to give privileges to any user under the defined grant option.
