Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ How to allow users to access only a specific database (MSSQL)     - Use in Linux ipmitool tool (Linux)

- Introduction and use of the Raspberry Pi (Linux)

- Elaborate .NET Multithreading: Thread Pool (Programming)

- Chkconfig command Detailed service is added and shut down the system in two ways to start service under Linux (Linux)

- CentOS RedHat YUM Source Extensions Supplement (including 32-bit, 64-bit) (Linux)

- What is Unikernel? (Linux)

- Linux system commands to view hardware information (Linux)

- Python dictionary applications get built-in method (Programming)

- Grep, Ack, Ag searches Efficiency Comparison (Linux)

- Android WebView use layman (Programming)

- Seven kinds of DDoS attack methods and techniques Defensive (Linux)

- Linux modify the system time (Linux)

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

- CentOS How quickly customize kernel binary RPM package (Linux)

- CentOS build JDK environment (Linux)

- MySQL5.7 implement virtual column expression index (Database)

- To generate a certificate using OpenSSL under Linux (Server)

- The Rabbitmq installation under CentOS 6.4 (Linux)

- VMware installed Linux system and JDK deployment (Linux)

- To install Spotify in Ubuntu / Mint (Linux)

 
         
  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:      
 
- Python in os.path Magical (Programming)
- Linux command in the dialog whiptail (Linux)
- Linux POST fstab configuration file read-only variable can not be modified problem (Linux)
- Optimized to minimize the installation of CentOS 5.8 (Linux)
- Oracle through the alarm log view and inspect the main library, physical and snapshot standby database (Database)
- CentOS6 installation configuration rsh (Server)
- Linux Shell Scripting Interview Question (Linux)
- Security: Unix operating system intrusion tracking Strikes Back (Linux)
- CentOS of NFS (Server)
- JavaScript function definition mode (Programming)
- MySQL dual master configuration (Database)
- Linux port mapping system (routing and forwarding) (Server)
- Android 5.1 OTA package compilation error (Programming)
- Linux environment to build next Cocos2dx-3.3.1 (Linux)
- You may not know the Linux command-line network monitoring tool (Linux)
- Install Web-based monitoring tool: Linux-Dash (Server)
- How to track performance issues when using the Unity Game Development Android (Programming)
- How to install and configure the KVM and Open vSwitch on Linux distributions (Linux)
- Oracle procedure or function Empty Table (Database)
- SQLite (Database)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.