August 28, 2007 at 9:03 pm
Hi,
we have one database with four schemas
I want to create four user with database owner rights for four programmers, and track the performance of query based on their id and their connections.
my question is, for tracking should i create four user under one login or
four user under four logins and i want to give acesses for all the schema to these users.
when we move from dev to prd there will be only one user.
pls send me the script. thanks
August 29, 2007 at 8:20 am
I do not think that you can create four database users in the same database for the same login.
Regards,
Andras
August 30, 2007 at 10:12 am
Buy something. There are very good tools out there to track what you are asking for historically.
Idera and Quest both do that very well. To track performance data you have to do much more than a simple script.
As for 4 users, 4 schema's and 4 logins? Not sure what it is you are really trying to accomplish here.
September 2, 2007 at 11:34 pm
Thanks for your reply, i want to track on the programmers like who has deleted the tables and who has inserted and so on.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply