December 12, 2007 at 4:06 pm
:hehe: Hi all I am in a situation, So I need experts advices please help. This is the security issue.
We have a client database and the end product uses the JDBC and as such each user/database combination is assigned a pool
of connections.the connection to database is made with connection pool as there is only one single user
with dbo rights and we have a logingroup mapped to that user. As the activity on a database is getting high with different
members from login group.
Now our client wants to create anothe user on the database with the dbo rights for the same loginggroup.
Can you guys please advice what could be the possible impact of this. The way I was thinking was what if the two users
tries to write to a same table at the same time. There are lot of other doubts going on.
So please help. Sorry if I am unable to explain the situation clearly.
I know this is little messy,
Thank in Advance.
December 12, 2007 at 9:22 pm
SQL Server handles the locking. There's no reason to worry about two users writing at the same time. Each connection is separate and locking occurs on a first come first serve basis.
I can log in as myself, with dbo rights, from 10 different computers, submit changes to the same row on all computers and SQL Server will determine the locks.
Do they really need dbo rights? Are they creating objects, running backups, etc? Mostly likely you should just set up a role for this user and grant the appropriate rights.
December 13, 2007 at 7:03 am
Does it mean i can go ahed and create two users for same login group.'
Thank You.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply