How to prevent DDL, DCL, TCL commands in Oracle Query

Question

Hi guys,

I'm developing an application to perform SQL query's from ASP.NET in ORACLE and I want to get a list of all DDL, DCL, TCL reserved words to prevent changes to database.

Maybe, ¿There is a database table in oracle with this list? like v_$reserved_words.

I will really appreciate your help guys, and the solution has to be right that way, because i connect to database with an generic user with all privileges and my company doesn't allow me to change that.

Answer 1

Just create a new user and give him the connect role and just select permission on the tables, views he is allowed to see.

create user test identified by notagoodpassword;

grant connect to test;

grant select on schema.table to test;

Edit: if you want the user to call a procedute/function you need

grant execute on schema.procedure to test;