Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    35

    Unanswered: T-SQL - How to grant Public access to a DB for a user

    I need an example of how to grant access to a SQL user to a DB. For the life of me I can't seem to get my syntax correct. My database name is TEST and my username is LEMME_IN and I want to grant the user "Public" access to the db with db_datareader, db_datawriter database role membership.

    Thanks

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    Hi,
    Simplified syntax for GRANT (SQL 2000)
    GRANT { ALL [ PRIVILEGES ] }
    | permission [ ( column [ ,...n ] ) ] [ ,...n ]
    [ ON [ class :: ] securable ] TO principal [ ,...n ]
    [ WITH GRANT OPTION ] [ AS principal ]


    In this link, you have the complete syntax:
    http://technet.microsoft.com/es-es/l.../ms187965.aspx

    any error? tell me.
    Bye.
    Abel.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •