| How to create Read-only Oracle user? [message #50617] |
Mon, 25 March 2002 15:00  |
tax_man
Messages: 10
Registered: March 2002
|
Junior Member |
|
|
Hi,
Can someone PLEASE help me out here!
I have an Oracle8i DB, for which I would like to create a user that has read-only access to all TABLES and SEQUENCES (ie, only SELECT access, NO ALTER, DELETE and UPDATE). I'd like to do this using the Oracle "DBA Studio" utility.
The purpose is so that while browsing table data in a tool like TOAD, I dont accidentally change any values.
Your help is much appreciated.
THANKS A MILLION!!
|
|
|
|
| Re: How to create Read-only Oracle user? [message #50622 is a reply to message #50617] |
Tue, 26 March 2002 01:38  |
Epe
Messages: 99
Registered: March 2002
|
Member |
|
|
Yow,
one way is to create a role and grant only select-privileges to that role (and giving that role to the user off course).
==> create role RO;
==> grant select on ... to RO;
...
==> create user URO;
==> grant RO, create session to URO;
Success !
Epe
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
