Ora-06502: Oracle scripts and errors

We can revoke priviliges on tables and functions/procedures using REVOKE. Let’s see a couple of example to better understand it.
We can revoke privileges for common DML statements (select, insert, update and delete). We use sentences like this:
REVOKE select, insert ON mytable FROM myuser;
We can also revoke privileges for some DDL statements. If we want to […]

We can grant priviliges on tables and functions/procedures using GRANT. Let’s see a couple of example to better understand it.
We can grant privileges for common DML statements (select, insert, update and delete). We use sentences like this:
GRANT select, insert ON mytable TO myuser;
We can also grant privileges for some DDL statements. If we want to […]