Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbashalini
Starting Member
3 Posts |
 Posted - 2007-12-12 : 18:27:57
|
| 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 poolof connections.the connection to database is made with connection pool as there is only one single userwith 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. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-12 : 23:06:57
|
| Sql has locking mechanism so don't worry about writing to table at same time, no matter by one user or ywo users. The question is why user needs dbo rights. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-12-13 : 11:53:57
|
| I think your question is more on auditing user transactionsyour end product should be able to handle this... adding new usersbut if your client request is direct database access with dbo rights1. you should check your company policy2. if there is no problem, just add the user but don't map it to the same application user, just provide DBO as isYour client asking you to map the new user sounds like they don't have a DBA or anyone knowledgeable to do it...I am always skeptical about giving power to those who know less (usually they become too cocky and feel like instant gurus)--------------------keeping it simple... |
|
|
|
|
|
|
Security- question please help