On SQL 2005 and above, how can I find users and database level permissions mapped to a certificate?
Story behing this: I copied a database from SQL 2005 to SQL 2008. It had a certificate inside the database which got copied over with backup and restore (as far as I can see). I am not seeing any server level credentials for this certificate on both source and destination server and can see this inside the user database using the following code:
select * from sys.certificates
I couldn't find a certificate file on the server corresponding to this certificate. I doubt the following with this:
- Did the certificate get copied correctly?
- Did the logins get mapped automatically?
- Did it loose any of the permissions on the database objects?
- How can I find a file corresponding to this certificate?
I just want to make sure that If the logins were granted permissions using a certificate, then I should be able to see and retain the permissions. The database doesn't have encrypted data.
Thanks in advance..