Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ How to allow users to access only a specific database (MSSQL)     - Use source packages compiled and installed GCC5.1 in Mac OS X 10.10.3 (Linux)

- Oracle database online redo logs are several methods of recovery of deleted (Database)

- iOS constants, variables, properties and characteristics (Programming)

- Hadoop 2.7.1 Installation and Configuration under RedHat Linux 6.5 (Server)

- Oracle and MySQL difference between the jdbc (Database)

- Text analysis tools - awk (Linux)

- Subsequent binary search tree traversal sequence (Programming)

- Connect to the Oracle Database Help class (Database)

- CentOS iptables firewall configuration (Linux)

- Linux environment variable configuration and save places (Linux)

- Shell Script: create a function and specify a directory for download (Programming)

- Linux Operating System Security Management Experience (Linux)

- Detailed driver compiled into the Linux kernel (Programming)

- Tmux Getting Start (Linux)

- Linux alpine use the command line to access Gmail (Linux)

- Java String and StringBuffer and StringBuilder Comments (Programming)

- How to view the Linux program or process used in the library (Linux)

- MBR partitions under Linux (Linux)

- Linux foundation tutorial: how to modify the host name on CentOS or RHEL 7 (Linux)

- Schema snapshot rollback (Database)

 
         
  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:      
 
- Oracle 11g forget approach SYS and SYSTEM password (Database)
- Oracle Client Easy Connection error ORA-12154, TNS-03505 (Database)
- The compiler installed Kaldi under Ubuntu 12.04 (Linux)
- Linux file permissions chmod chown (Linux)
- Linux Network Security Tips Share (Linux)
- Nginx version information hidden or modified (Server)
- Linux Getting Started tutorial: hard disk partition and to deal with traps (Linux)
- Laravel 4.2 Laravel5 comprehensive upgrade Raiders (Server)
- How to install Ubuntu applications Device 7 (Linux)
- Kickstart automated installation and deployment RHEL 7.0 (Linux)
- Share Practical Tutorial GitHub (Linux)
- Install Oracle JDK 8 and JVM class loading mechanism in Linux (Linux)
- Java static internal class (Programming)
- Java annotations entry automatically generates SQL statements (Programming)
- CentOS 7 RHEL 7 to reset the root password (Linux)
- Use FFmpeg processing high quality GIF (Programming)
- Cool Android realization SVG animation (Programming)
- Linux Log (Linux)
- Modify Linux SSH default port 22 in several ways (Linux)
- Linux use additional rights (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.