Read only roles or accounts

#1

How can I set an account or role so that it only have read access to the
database? I have check the doc. that it only allow me to grant that right on
the table level.

#2

Kenneth wrote:

Quote:

How can I set an account or role so that it only have read access to the
database? I have check the doc. that it only allow me to grant that right on
the table level.

you have to explicitly grant select access on each table to the read

only role. Its not that hard to setup - just a pain to keep it up to date.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Read only roles or accounts

comp.databases.sybase comp.databases.sybase

Read only roles or accounts - 07-02-2003 , 08:13 PM

Re: Read only roles or accounts - 07-06-2003 , 05:41 AM