sql - What permissions should be granted to the remote user to do anything with "the database" and no other? -


To do anything from the database in SQL Server 2005 Express, what remote user should be allowed to do that any remote user Can not do anything in other databases?

I also like that remote users can not see other databases. This "123" is for user login using SQL authentication method. it's private.

I am using both SQL Server Management Studio Express 2005 and Web Server Database Server.

Connecting to the webserver database server. "Nick Thomas replied that what something means, but later he has removed his answer, so that what the user can do for other respondents."

"Do all: Anything related to tables, tables, delete, editing / update tables, insert, remove, and function on all tables. But a user can not leave the database, the database drop should be restricted.

Insert, update, and delete on the table.

Create, change, and leave tables.

Table copy, database backup. Take a look at


Comments