tables protect in sqlserver 2000

[lvthanh]

I have some tables in the employee database, this database created from sql sever 2000. I build a employee management application by C# and sqlserver 2000.

My goal is after design complete the empployee database by sqlserver 2000, any users can not modify my tables and unkonw table's structure.
help me please

thanks and reagards

[skhanal]

I am assuming by modification you mean structural modification not data modification.

Give the application user read write privilege only on the database.

There are fixed role called db_datareader and db_datawriter that you can use.

[MAK]

If you dont want to give access to certain employees then you can maintain a separate login table and control the access from c# by selecting that login table.

or

if you just dont want to allow users to do structure changes then follow Skhanal's advise.

or

If you dont want certain employess to access anything on your database either deny access or dont add their logins as users.