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 |
|
spareus
Yak Posting Veteran
52 Posts |
 Posted - 2009-11-10 : 01:11:21
|
| I have set up an database in sql 2000 enterprise manager.I am totally new in this field of SQL.Currently everyone can access my database.Kindly help me how can I restrict access only to a few defined PC/users.Regards,Spareus |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
spareus
Yak Posting Veteran
52 Posts |
Posted - 2009-11-10 : 02:33:32
|
| Thanks for your help.My computer is having local admin only for me and domain administrators.Security\logins are only defined for one computer.Still other PC's are able to access. Have I missed something?Thanks again.Regards,Spareus |
 |
|
|
spareus
Yak Posting Veteran
52 Posts |
Posted - 2009-11-10 : 02:35:15
|
| Why are you using SQL Server 2000 though?This is the only available version with our admin.Thanks.Regards,Spareus |
|
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2009-12-01 : 10:27:59
|
| That is implied in the GRANT statement: GRANT SELECT ON databasename.* TO 'username'@'hostname' ... ; (where hostname can be a literal FQDN or an IP address or something with a wildcard). Be sure to remove any users from mysql.user where hostname is not specified (or is a %) if you wish to lock down the database.<spam removed> |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-01 : 10:49:04
|
| Wow, more spam along with an incorrect answer. |
|
|
|
|
|
|
How to restrict access