Create READ ONLY Login Sql 6.5

[sharon greene]

I use Sql 6.5 and I want to create a login for a user with
READ ONLY privileges on the tables in the databases. How do I do this?
Thanks in advance.

[Ray Miao]

Create login and grant it read only permission.


------------
sharon greene at 6/8/00 3:35:04 PM

I use Sql 6.5 and I want to create a login for a user with
READ ONLY privileges on the tables in the databases. How do I do this?
Thanks in advance.

[SHARON GREENE]

Thanks Ray for your response. I created the login then I tried to do
the following but received an error:

GRANT READ ONLY, ON TOMS52 TO MLEVITT (TOMS52 is the database)

What am I doing wrong? thanks again.


------------
Ray Miao at 6/8/00 4:46:33 PM

Create login and grant it read only permission.


------------
sharon greene at 6/8/00 3:35:04 PM

I use Sql 6.5 and I want to create a login for a user with
READ ONLY privileges on the tables in the databases. How do I do this?
Thanks in advance.

[Bill]

Make sure you are in the correct database.

GRANT SELECT on tablename to username or group.

or use Enterprise Manager

------------
SHARON GREENE at 6/9/00 8:40:54 AM

Thanks Ray for your response. I created the login then I tried to do
the following but received an error:

GRANT READ ONLY, ON TOMS52 TO MLEVITT (TOMS52 is the database)

What am I doing wrong? thanks again.


------------
Ray Miao at 6/8/00 4:46:33 PM

Create login and grant it read only permission.


------------
sharon greene at 6/8/00 3:35:04 PM

I use Sql 6.5 and I want to create a login for a user with
READ ONLY privileges on the tables in the databases. How do I do this?
Thanks in advance.