dcsimg
Results 1 to 4 of 4

Thread: Create READ ONLY Login Sql 6.5

  1. #1
    sharon greene Guest

    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.

  2. #2
    Ray Miao Guest

    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.

  3. #3
    SHARON GREENE Guest

    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.

  4. #4
    Bill Guest

    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
  •