Create User with Profile Only for Query

[antonio.rodrigues]

Hello, someone can help me with a tutorial, explain how
create user with profile only for consultation in Oracle.
I need this much, thank you

Antonio.rodrigues@scientific.med.br

[elidias7]

Good Morning.

You can create the user with the following commands

You can create the user with the script below by changing the login, password and tablespace options.

Select all

create user nome_usuario identified by senha_usuario 
account unlock 
default tablespace nome_tablespace (esta tablespace geralmente é utilizada a users, agora se eles especificarem outra não tem problema) 
temporary tablespace temp; 
 
grant create session to nome_usuario;

Now the question of privilege, you need to check with who asked you if the user will have permissions on any table or only in some defined, for example:

# For all tables in the bank:

Select all

Grant select any table to nome_usuario; 

This is not very recommended at security level)

# for client-defined tables:

Select all

Grant select on table_name to nome_usuario; 

Hugs,

[antonio.rodrigues]

: D, Thanks for the script, I'll apply here.

[diegoleite]

Friend,

Beware of grant select any tables .. Not recommended! Even if it comes to a test base !!!! Imagine an instance with payroll schema, and this information were available for people who should not have these available information.

Ideal will be a dynamic script.

Select all

select 'grant select on '||table_name||'to NOMEUSUARIO;' 
from all_tables where owner='NOMEDOOWNER';