Results 1 to 2 of 2

Thread: sysusers table

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: sysusers table

    Hi,

    In SQL Server, if I active the application role, can all the public user still read the sysusers table even though the application role does not select the sysusers as read permission?

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    All system tables are available to all users, regardless of whether they are in an application role or not. You should be able to prove this in a simple test.

Posting Permissions

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