-
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.
-
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.
-
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|