lock table

[wdu94]

Hello,

I have the userName_Password table. I want to lock it, but I don't know how to lock it. I am a newer for SQL server.

Thanks for your help.

Jeannia

 

[fluteplr]

Do you mean lock or do you mean set security on it so only certain people can see it? Lock has a specific meaning in SQL related to preventing anyone from updating a table for a specified period while some transaction is going on.

If you mean secure it as I suspect. Go into enterprise manager right click on the tablename and select all tasks, permissions.

You might want to reconsider why you are setting up a user/password table rather than using the build in security of SQL server, which would avoid this problem in the 1st place.

 

[wdu94]

Hi, fluteplr,

Thanks for your reply. Because my project is MS Access Project and connect to sql server. That's means the tables, stored procedures, views are stored in the sql server and the forms and reports are stored in the MS Access. This project have four parts databases. I created main form, everything is begin from the main form and also have 'Login' for each database depend on different department's people. Therefore, I want try to set up security to lock this table.

Thanks again.
Jeannia