Results 1 to 2 of 2

Thread: user pemissions

  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: user pemissions

    I wanted to give my sql server user to give select,insert,update on all the tables and execute permission on all the stored procedures.He should get the permissions on the object which will be created in the future.How can i do this.

    Thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to the books online for the FIXED DATABASE ROLES topic and assing DB_DATAWRITER role to this user using GRANT statement.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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