Hi,
I created a user and a new role and I want to give read/write access on the schema to the user. But schema doesn't have any objects in it.
1) Can we still give read/write access on schema to user? If so can you provide me syntax and statements for the same.
2) Also when I say read/write do read/write access include DELETE along with INSERT and UPDATE statements.
3) If we can grant read/write access to user on a schema , my next question is can we include SELECT ANY, INSERT ANY, UPDATE ANY TABLE grants to role and then GRANT ROLE TO USER.
Can you please let me know