We have a oracle database and i need to set up a user with username 'acct_Dani' and password 'gT54rlo' and make it so this account only has view rights (in other words cant use update, replace or delete)
What is the sql code that i need to use to run this.
Also i know i can use
select * from all_users
-- view all users
Select * from SESSION_PRIVS
-- view all possible privelidges
but how do i view all priveledges for a specfic user