CODEWITHSUNDEEP
sqlsql-serversql-server-2014
David Williams
David Williams

Reputation: 390

How can I find out which tables and stored procedures a database user has accessed?

Is there a way to find out which tables and stored procedures a user has accessed? Note that this is what the user has actually accessed and not what they can access.

For tables, is it also possible to know whether the access was read or write?

I would like this information to determine which database privileges can be removed for this user.

Upvotes: 2

Views: 93

Answers (1)

SQL Police
SQL Police

Reputation: 4206

It is possible, but not for the past. On SQL Server 2014, you can setup specific monitoring tasks (called "audititing"), so that from now on you can collect the access data you want.

Upvotes: 1

Related Questions