Skip to main content

Steps to create user in database

Creating test user in oracle database


alter session set container=testdb--only for 12c
create user test identified by test;
grant create session to test;
grant create table,create view to test;
grant  create procedure to test;
grant create synonym, create trigger to test;
grant unlimited tablespace to test;

Comments