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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-11 : 14:05:31
|
| Louis writes "Hi,I am porting MySQL DB to MSSQL2000. My question here is, how can i grant permission to certain user base on host and user? Just like what MySQL grant option.ThanksLouis" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-11 : 14:38:35
|
| Don't know what you mean by host, in this context it doesn't mean anything in SQL Server. But you can GRANT, DENY and REVOKE permissions to individual users for any object in a database, an entire database, and even access to an entire server. You can also create database roles and assign permissions to the role, and add any user to those roles (there are also predefined database roles) There are also server-level roles that allow various levels of administrative functions; these are fixed roles however.SQL Server Books Online (installed along with the server software) has plenty of information on users, logins, roles and permissions. You can also try the top links provided here for online versions:http://www.sqlteam.com/SearchResults.asp?SearchTerms=books |
 |
|
|
|
|
|
GRANT permission to specific host and user