Search code examples
oracle-databaseddlreserved-wordsdml

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

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.

Solution

  • 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;