[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Default permission and encryption question

unknown

3/8/2007 8:15:00 PM

SQL Server 2005 express. Two questions.....

1. What are default permissions of the owner of the schema with regard to
objects (tables, stored procedures belonging to particular schema)? Same
for database owner? Will the owner have all permissions by default or do i
need to explicity grant permission?

2. As a sysadmin (or as the owner of the certain database), will I be able
to recover keys used to encrypt certain data columns in a table even though
I did not create that key? If so how can I recover that key?

Thanks