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.
Printable View
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.
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.
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.
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.