Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ How to allow users to access only a specific database (MSSQL)     - JavaScript basic tools list (Programming)

- TypeScript basic grammar (Programming)

- Virtual Judge environment to build and configure under Ubuntu (Server)

- Chkconfig set boot start under Linux (Linux)

- Oracle RMAN-06023 and ORA-19693 errors (Database)

- CentOS iptables firewall configuration (Linux)

- Docker study notes (Server)

- How Mutt mail client to use cipher text password (Linux)

- The specified user to execute commands under Linux (Linux)

- JavaScript in this usage (Programming)

- Linux modify the system time (Linux)

- Linux system security mechanisms to share (Linux)

- Linux install the Java Runtime Environment and the output Hello World under (CentOS) (Linux)

- Java memory area and memory overflow exception (Programming)

- IO reference Docker container (Server)

- Vim configuration instructions (Linux)

- SSH without password Definitive Guide (Linux)

- Configuring DNS process under CentOS 6.5 (Server)

- Android Studio installed in Ubuntu 15.04 (Linux)

- Boost notes --Asio - (1) a simple small example of synchronous communication (Programming)

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

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.

solution

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]
go
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)

Explanation:

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
     
         
         
         
  More:      
 
- Use IP address spoofing Intrusion Prevention Firewall (Linux)
- How to prevent page five invisible killer (Linux)
- RPM package management tools under Linux (Linux)
- Debian 8 Jessie install LAMP server tutorial (Server)
- Use Bash script write CVS version control (Server)
- How to modify the SQL Server auto-increment value and the corresponding solution (Database)
- The Definitive Guide to Linux NAT network connection (Linux)
- Linux remote landing system (Linux)
- RM Environment Database RMAN Backup Strategy Formulation (Database)
- How to configure chroot environment in Ubuntu 14.04 (Linux)
- cat command uses the Linux redirection merge files (Linux)
- numpy and SciPy installation under Python for scientific computing package (Linux)
- MySQL monitoring tool -Innotop (Database)
- Linux user login ban (Linux)
- CentOS 6.5 installation VNCServer implement graphical access (Server)
- To teach you a trick to find the real IP address (Linux)
- Vagrant build LNMP environment (Server)
- Awk include binding capacity larger than the specified size of all files directory (Linux)
- Installation and Configuration ISC DHCP server on Debian Linux (Server)
- Docker data container protection the pros and cons (Server)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.