database security

i a the user of sql server 2005 on window server 2003. i want to know
that how can i prevent my database from other user logins because all
of them are sysadmin type.
and i am also looking for database concurrency control methods.

if any one know about this plz mail me answer on this mail id
mahendersingh_be@.yahoo.co.in
thanx in advanceOn 11 juin, 13:00, Mandy <mahendersing...@.gmail.comwrote:

Quote:

Originally Posted by

i a the user of sql server 2005 on window server 2003. i want to know
that how can i prevent my database from other user logins because all
of them are sysadmin type.
and i am also looking for database concurrency control methods.
>
if any one know about this plz mail me answer on this mail id
mahendersingh...@.yahoo.co.in
>
thanx in advance

Hi,
You can use SQL Server authentification, open MS SQL manager then
change the connection of the current server
Omar Abid|||Mandy (mahendersinghbe@.gmail.com) writes:

Quote:

Originally Posted by

i a the user of sql server 2005 on window server 2003. i want to know
that how can i prevent my database from other user logins because all
of them are sysadmin type.

In that case you would need to move the database to a different
instance where the other people can't get in. No protection from other
sysadmin on a aserver.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

DataBase Role

Hi
I want to add my database role to a server fixed role like other logins but
I can't.
Please help me.
Thanks
Mehdi> I want to add my database role to a server fixed role like other logins
> but
> I can't.
You can add only logins to fixed server roles.
Dejan Sarka
http://www.solidqualitylearning.com/blogs/|||> I want to add my database role to a server fixed role like other logins
> but
> I can't.
Logins are server-level so you can add logins to server roles. Since
database roles are only recognized only within the scope of that database,
database roles can't be added to server roles.
What are your security requirements? Perhaps you can grant the desired
permissions directly to the database role.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mehdi" <Mehdi@.discussions.microsoft.com> wrote in message
news:46F5EB48-DBE0-43EC-8D3C-501E02F496EA@.microsoft.com...
> Hi
> I want to add my database role to a server fixed role like other logins
> but
> I can't.
> Please help me.
> Thanks
> Mehdi