•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 374,006 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,741 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 255 | Replies: 1
 |
•
•
Join Date: Apr 2008
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi all,
My server will have multiple databases and I want, for security purpose, to have one user per database. This user will only be able to access that one table and no other. This user will have all rights to this database only.
I created my first database/user combo and it seems to work, however, when I go to the second table/user the new user can no longer access the newly created database.
The user I want to create is going to authenticate only to the SQL server not to Windows.
User Database
joe joe_db
paul paul_db
john John_db
P.S. The user will have full rights to its database and none to anyone else's
Thank you in advance!
My server will have multiple databases and I want, for security purpose, to have one user per database. This user will only be able to access that one table and no other. This user will have all rights to this database only.
I created my first database/user combo and it seems to work, however, when I go to the second table/user the new user can no longer access the newly created database.
The user I want to create is going to authenticate only to the SQL server not to Windows.
User Database
joe joe_db
paul paul_db
john John_db
P.S. The user will have full rights to its database and none to anyone else's
Thank you in advance!
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
•
•
•
•
age amd avatar backup blue gene breach business chips daniweb data data protection database development dos economy energy enterprise europe government hacker hardware hp ibm ibm. news intel ibm it linux medicine memory microsoft news open source openoffice pc ps3 recession red hat russia security server sql sun supercomputer supercomputing survey technology trends ubuntu working x86
- Previous Thread: Link server in MS SQL 2005
- Next Thread: Query logic
