Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine user access 1

Status
Not open for further replies.
dpheat28

dpheat28

MIS
Jul 17, 2001
11
US
Does anybody know how to determine what user account was used to grant access to another account in a database?
 
Sort by date Sort by votes
Unfortuantly SQL Server does not retain that kind of information.

Rick.
 
Upvote 0 Downvote
Actually SQL Server does track the Grantor of permissions. Use the system stored procedure sp_helprotect to view all permissions on all objects in a data base. You can use various options to view permissions on objects, permission for a specific user or permissions granted by a user. See the complete documentation in SQL BOL. Terry L. Broadbent
Programming and Computing Resources
 
Upvote 0 Downvote
dpheat28 my applogies I've not come across sp_helprotect before.

Thanks for the correction Terry.

Rick.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
413
gmmastros
gmmastros
new_to_sql
  • Locked
  • Question
Access SQL Query Error
Replies
5
Views
145
dhookom
dhookom
Auguy
  • Locked
  • Question
Determine sa Password When Signed On As Administrator User Thru Windows Authentication 1
Replies
2
Views
85
Auguy
Auguy
grnzbra
  • Locked
  • Question
Determine Table Columns Associated with View Columns
Replies
4
Views
86
iambob
iambob
Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
128
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top