Create READ ONLY Login Sql 6.5

Printable View

06-08-2000, 02:35 PM
sharon greene

Create READ ONLY Login Sql 6.5

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.
06-08-2000, 03:46 PM
Ray Miao

Create READ ONLY Login Sql 6.5 (reply)

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.
06-09-2000, 07:40 AM
SHARON GREENE

Create READ ONLY Login Sql 6.5 (reply)

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.
06-09-2000, 03:19 PM
Bill

Create READ ONLY Login Sql 6.5 (reply)

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.