amit

• May 1st, 2007

 

Using grant command in sql we can grant complete database access to an user to read as follows

Grant read
on tablename
to username;

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 26th, 2007

 

No we cannot do that. we can make the full database in restricted mode in which only restricred users will have the access the use the database.

kashyap_aseem

 Profile Answers by kashyap_aseem 

• Feb 14th, 2008

 

grant select on table_name to user_name ;

if i am not wrong
Plz corect me

rajendra_thanekar

 Profile Answers by rajendra_thanekar 

• Apr 9th, 2008

 

hi,

You can put the entire database in read only mode.

startup mount
alter database open read only;

mangeshchede

 Profile Answers by mangeshchede 

• Mar 21st, 2010

 

By using following SQL Command you can grant read only privillege to your user on whole database.

SQL > grant select any table to user_name;

and dont grant any other privilege to that user.