How to make a protected password field

[muddasirmunir]

I am using sql server 2000 personal edition.

I want to know how can we make a password field in the table , so if any ope open the talbe it will only see ********** (even the admin) .

Hope you understand what i mean.

[Delerna]

As far as I am aware you cannot create a field in a table that does that.

Sql server provides logins under security for that sort of thing

With that login you can then control the level of access any user has to
any database object (tables,views,s tored procs...)
in any database.

Not sure if personal edition has that though

[muddasirmunir]

So , is there any way i can protect my whole sqlserver 2000 (Enterprise Manager) so no body can open it with out password , even the computer administrater to see my database and tables.

[ck9663]

Whoever the admin can see everything. Encrypt those fields that needs to be hidden.

Good Luck!!!

~~ CK

[ThatThatGuy]

I am using sql server 2000 personal edition.

I want to know how can we make a password field in the table , so if any ope open the talbe it will only see ********** (even the admin) .

Hope you understand what i mean.

You can encrypt the password externally and store it

[muddasirmunir]

You can encrypt the password externally and store it

Yes ,encrypt externally is a good option.

But i donot know how what utility is best for it , might be notepad and I also donot know how to write,read,encr ypte and decrypte notepad. Any link to good tutorial about this topic?

[ThatThatGuy]

Yes ,encrypt externally is a good option.

But i donot know how what utility is best for it , might be notepad and I also donot know how to write,read,encr ypte and decrypte notepad. Any link to good tutorial about this topic?

http://www.codeproject.com/KB/cs/Cryptography.aspx

has a good article on encryption and decryption using C#

[ck9663]

Here, read this.

Good Luck!!!

~~ CK