December 25, 2008 at 10:52 pm
hi all
Problem
----------------
There are number of databases in my SQLExpress-2005.. like..
1: Master
2: Pubs
3: Inventory..
My application related database is Inventory...
Requirement..
-----------------
1: No can open that database..
sug..
-------
I can do it by adding users... but the problem is like whenever user is giving windows authentication then any1 can see.. so how to lock my database...in windows authentication mode also..
susant
Susant
9967487567
December 26, 2008 at 8:17 am
I'm not sure what your question is. If you want to limit access to your database you do that through logins (access to the database server, which can be Windows users or groups) and then map those logins to database users within your Inventory database. Then Best Practices would require creating roles within the database and assigning users to the roles. The roles would have rights to the objects within the database, the users would not.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 26, 2008 at 8:21 am
Duplicate post. Please post answers here
Please don't post multiple times at it fragments responses and wastes some people's time as you may get similar responses on each thread.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply