I want to give certain authorizations to users who connect to the database. The scenario is as follows; users will be able to assign select queries to the tables and access the tables, but only users who are admin will be able to see the create scripts. How should I follow a path for this. I want to hide the query in the picture when connected from Oracle db or when entering the DDL content of the table from the terminal. How do you suggest a way to do this?
