February 7, 2007 at 1:08 pm
Hi guys. Sorry if this is in the wrong spot on the forums. This is my first foray into MSSQL of any kind so go easy on me
Edit: Doh. Must have hit submit by mistake. Sorry bout that!
I've got what I think should be an easy question to answer, but the more I read on the subject the more confused I get.
What I want to do is this: I want create one user, and ONLY one user, that has master access to my SQL Server 2005 Express instance.
I understand I can use Windows Authentication to grant access to administrator level users. But the problem is I need to exclude all other administrators from gaining access to this database. In other words, Admin1 should have full access, but Admin2 should not, nor should any other user created by Admin2.
I'm coming from the MySQL world and this was trivial to implement. So I'm sure I'm overcomplicating this...
Thanks in advance guys!
PS: I will be adding users that have access to specific tables within the SQL Server (for client access via ADO.Net programming). And I think I understand that...
February 8, 2007 at 8:34 am
Bump. Anyone have any thoughts on this one??
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply