locked
Authorizing Users to Access Resource RRS feed

  • Question

  • hi all

    Can anyone show me how to Authorize Users to Access Resource in SQL SERVER 2008 R2?

    • Moved by Mr. Wharty Sunday, January 27, 2013 7:27 AM Not a training and certification question
    Sunday, January 27, 2013 2:38 AM

Answers

  • You should probably ask this in one of the SQL Server Forums instead of the Training and Certification forum:

    http://social.technet.microsoft.com/Forums/en/category/sqlserver

    http://social.msdn.microsoft.com/forums/en-US/category/sqlserver/

    But anyway, to authorize users you could execute a DCL statement of the type:

    GRANT permission TO user ON resource

    or do the equivalent from SQL Server Management Studio by selecting the options on the Permissions tab in the Properties window of the corresponding resource. Alternatively, make the user a member of a role that already has the required permissions (such as db_datareader and db_datawriter if the resource is a database). If you need to expand on these topics, it is better to ask it in the SQL Forums (linked above).

    • Proposed as answer by Mr. Wharty Sunday, January 27, 2013 7:27 AM
    • Marked as answer by Maggie Luo Monday, February 4, 2013 11:09 AM
    Sunday, January 27, 2013 7:21 AM

All replies

  • You should probably ask this in one of the SQL Server Forums instead of the Training and Certification forum:

    http://social.technet.microsoft.com/Forums/en/category/sqlserver

    http://social.msdn.microsoft.com/forums/en-US/category/sqlserver/

    But anyway, to authorize users you could execute a DCL statement of the type:

    GRANT permission TO user ON resource

    or do the equivalent from SQL Server Management Studio by selecting the options on the Permissions tab in the Properties window of the corresponding resource. Alternatively, make the user a member of a role that already has the required permissions (such as db_datareader and db_datawriter if the resource is a database). If you need to expand on these topics, it is better to ask it in the SQL Forums (linked above).

    • Proposed as answer by Mr. Wharty Sunday, January 27, 2013 7:27 AM
    • Marked as answer by Maggie Luo Monday, February 4, 2013 11:09 AM
    Sunday, January 27, 2013 7:21 AM
  • It would be a good idea to review Authorization and Permissions in SQL Server & it will also help with basics right.

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful, if a post was useful to help other user's find a solution quicker.

    Monday, January 28, 2013 9:53 AM