Silahkan Melihat Tutorial di website kami dengan nyaman ENJOY YOUR LIFE ☕

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;





0 komentar:

Post a Comment

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