How to create a role and grant the role for user/schema in Oracle Database

create role "DEV" NOT IDENTIFIED;
       
grant CREATE TRIGGER to "DEV";
grant CREATE SEQUENCE to "DEV";
grant CREATE TABLE to "DEV";
grant CREATE TYPE to "DEV";
grant CREATE SESSION to "DEV";
grant "CONNECT" to "DEV";
grant CREATE JOB to "DEV";
grant CREATE LIBRARY to "DEV";
grant CREATE INDEXTYPE to "DEV";
grant CREATE ASSEMBLY to "DEV";
grant CREATE PROCEDURE to "DEV";
grant CREATE SYNONYM to "DEV";
grant CREATE VIEW to "DEV";

grant  DEV to schema_name;

Share this

Vtgdb