Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ How to allow users to access only a specific database (MSSQL)     - How to enhance the security of Linux systems (Linux)

- Build and verify MongoDB3.0.7 version (shard + replica) Cluster (Database)

- Tor Browser: under Linux for anonymous Web browsing ultimate browser (Linux)

- Security basics: simple analytical framework for Linux system firewall (Linux)

- Ubuntu security settings and tools (Linux)

- C ++: Postmodern systems programming language (Programming)

- Graphic Git (Linux)

- Servlet life cycle code examples (Programming)

- Linux more efficient than select a model epoll (Linux)

- The wrong in Linux: too many open files (Linux)

- Docker build private warehouse (Server)

- Household use Linux Security (Linux)

- Java memory model subclasses (Programming)

- Openfire achieve load balancing cluster by Nginx (Server)

- Increase Linux system security --chattr (Linux)

- MySQLbinlog combat on using data recovery (Database)

- Linux RPM default installation path (Linux)

- Java Timer (regular calling, to achieve a fixed time to perform) (Programming)

- Error code: 2013 Lost connection to MySQL server during query (Database)

- To install and deploy PHP environment under the CentOS (Server)

  How to allow users to access only a specific database (MSSQL)
  Add Date : 2018-11-21      

There are instances of SQL Server on the customer's multi-vendor databases, each carried by a respective plant maintenance providers, in order to define different manufacturers maintenance personnel can only access your database, it is required to define the respective manufacturers permission to let them login SQL Server can only see authorized database and other databases can not see.


1. Give a different vendors to create different login name (as a vendor with an example)

2. The login name is added to the public server role, and then click OK

dbowner 3. authorized database to be assigned to the user

Use [xjcs]
EXEC dbo.sp_changedbowner N'provider1 '
This time with 'provider1' log in SQL Server, you see only the specified user database (except the system database)


I want to set before the user login map in the first two steps to achieve this requirement, the following figure, but to no avail, log in to SQL Server database users still can not see
- Linux / Raspberry Pi using the following command-line based web browser (Linux)
- The practical application of Oracle synonyms + dblink (Database)
- A detailed introduction to the Hadoop ecosystem (Server)
- Linux daemon (Linux)
- Detailed steps - GAMIT solver (Linux)
- Python implementation Bursa transition model (Programming)
- Android Qemu GPS module (Programming)
- Use PuTTY to access the virtual machine Linux under Windows xp (Programming)
- ApacheDS configuration of users and user groups to achieve SSO (Server)
- Linux ban single-user mode to enhance system security (Linux)
- Video editing captions under Linux (Linux)
- To install Internet security firewall Raiders (Linux)
- Linux environment Duplex (multi-machine) automatic mutual backup scheme (Linux)
- How to install Unbound and DNSCrypt in Archlinux (Server)
- Ten to improve the efficiency of the Linux bash tricks (Linux)
- To batch create users under Linux (Linux)
- Sorting Algorithm (1) Quick Sort C ++ implementation (Programming)
- MySQL binlog automatic cleanup script (Database)
- Safety testing Unix and Linux server entry succinctly (Linux)
- JITwatch installation under Linux (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.