Hi,
I created a new schema in oracle development database. I want to provide read only and read write privileges to users on the newly created schema. Can you please let me know syntax which I can use to grant READONLY and READWRITE access on newly created schema(with no objects in it) for the users.
I generally create READ ONLY and READ WRITE roles as below and
READ WRITE ROLE:
grant create session, select any table, select any dictionary to DEV_READWRITE;
grant update any table to DEV_READWRITE;
grant insert any table to DEV_READWRITE;
READ ONLY ROLE:
CREATE ROLE DEV_READONLY NOT IDENTIFIED;
GRANT CONNECT TO DEV_READONLY;
grant create session, select any table, select any dictionary to DEV_READONLY;
Once roles are created I assign GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA.TBL_NAME TO DEV_READWRITE;
But how can we GRANT READONLY and READWRITE access on schema to users?
Can some one provide me syntaxt on providing access.
I also want to include DELETE privilege on schema objects to user in READWRITE access.