Re: Data Encryption In SQL2005

Yes, you need to have been granted special permissions for creating keys.
For details, look in Books Online; the permission requirements for DDL are
listed there.

Thanks

--
Laurentiu Cristofor [MSFT]
Software Design Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/

This posting is provided "AS IS" with no warranties, and confers no rights.

"Kumar" <Kumar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4DDBF38B-32FA-4284-A273-225F1D0B79A0@xxxxxxxxxxxxxxxx
> Mike,
>
> Thanks. Will try it. Do I need to have any special privileges to create
> all
> these keys ?
>
> thanks Kumar
>
> "Mike Epprecht (SQL MVP)" wrote:
>
>> Hi
>>
>> Have a look at Laurentiu Cristofor's blog
>>
>> http://blogs.msdn.com/lcris/default.aspx
>>
>> Regards
>> --------------------------------
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>>
>> IM: mike@xxxxxxxxxxxx
>>
>> MVP Program: http://www.microsoft.com/mvp
>>
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Kumar" <Kumar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:89F62EDD-1D58-4781-96CE-5FC5E6E82C8F@xxxxxxxxxxxxxxxx
>> >I am a developer and need to store some confidential information in my
>> >DB.
>> >I
>> > came to know about SQL server 2005's encryption features recently.
>> > I want to encrypt data in such a way that even DBA's who created the
>> > DB's
>> > (owners) should not be able to decrpt the data.
>> > Is it possibel in SQL server 2005 ? if so, can anyone breifly outline
>> > the
>> > steps or point to ncessary location.
>> >
>> > thanks. Kumar
>> >
>> >
>>
>>
>>


.

Relevant Pages

  • Re: Data Encryption In SQL2005
    ... you need to have been granted special permissions for creating keys. ... >>> Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: backup Keys
    ... "Back up the SQL Server 2005 encryption keys by using the corresponding SQL ... Regarding on the symmetric and asymmetric keys in SQL Server 2005 database, ...
    (microsoft.public.sqlserver.security)
  • Re: Why is this Not Updatable?
    ... have a Memo field. ... are there proper keys established on the SQL Server ... > warning that no changes can be made), do the primary key columns ...
    (microsoft.public.access.queries)
  • Re: Why is this Not Updatable?
    ... Bill To Info field instead of the BillToID field. ... are there proper keys established on the SQL Server ... > warning that no changes can be made), do the primary key columns ...
    (microsoft.public.access.queries)
  • Re: why default index for primary key is clustered?
    ... >> So why SQL Server created clustered index by default for primary key ... When you had sequential tape files, ... A master tape would be read in sorted order ... Please post DDL, so that people do not have to guess what the keys, ...
    (microsoft.public.sqlserver.programming)