Possible to password protect a SQL 2000 database table ?

[Webkins]

Hello, I am using MSSql 2000. I have a table where I store all my user ID's and information. I have many databases which access this table of information to validate user authorizations to other databases. Needless to say this table is very sensative. Is it possible to password protect this data from unauthorized access by other SQL database administrators here ?

Thank you for any suggestions or advice in advance.

 

[RiverGuy]

Users typically need passwords to make a connection to sql server. SQL Server allows you to grant specific permissions to specific objects. So in effect, you already have it built in, but you just need to manage permissions more effectively. You could also look at encrypting your passwords. I stored encrypted passwords generated from a .Net application in SQL 2000 once. I can't remember if SQL 2000 has any built in encryption.

 

[NastiaMurzin]

Here are a few scripts put in one on how to create and alter login name and password.
use tableschema;
create certificate MyTable
with subject = 'MyAdmin certificate in tableschema database',
expiry_date = '31/12/2009';
go
create login MyAdmin with password = 'passis01A' must_change from certificate MyTable;
go
alter login MyAdmin with name = Alex;
go
alter login Alex with password = 'passismine02';
go