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 |
|
golden_manish
Starting Member
13 Posts |
 Posted - 2003-06-26 : 11:39:09
|
| Sir or Madam,A really simple and stright forward question.Say i have a SQL Server Login, and A Database Login (Not Win NT Logins, SQL Server Logins).It helps me logon the the Server and the Database, through VB.But the logins do not stop any one from copying the DB or generating the SQL script.Is there any way i can stop users from accessing the Server without proper Logins, using any source, SQL Server itself, DMO or any other sa type login.Manish hereSigning Off |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2003-06-26 : 11:54:01
|
| you can goto Enterprise manager , click on security folder. you will get list of logins. double click your login, you will find Server roles and Database access.Read about server roles. and give only those roles which you are in line with your security policy.if you want to define security on object wise. double click on the object click on permissions button , you get the permissible logins on that db there. you can grant/revoke your permissions from there you can either allow or stop the user to select, insert , delete ,update and other stuff.-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
 |
|
|
|
|
|
|
|
Security