how to check users and roles
Posted on 2013-06-24
I have two sql server 2012 databases, once is a copy of the other but the data in the second one has been changed.
I can log into either database through the Server Management Studio using Windows authentication and update the databases.
However, when I connect through MS Access using a login (myacclogin (a user who is a member of db_owner)) which exists in both databases I get different results between the two databases.
In the first one, mylivedata, I can open up a table and update it.
In the second one, myarchivedata, clicking on the table link does not return any records.
As far as I can tell the permissions for the user are the same in both databases but can someone tell me how I can view what these permissions are so that I can check them.