User Profile
NikoT780
Copper Contributor
Joined Mar 18, 2023
User Widgets
Recent Discussions
Re: User management for a specific database
Hi Lain, thank you for the detailed explanation. I have created a "contained database". I completed the following steps: Step 1: USE [master]; GO EXEC sp_configure 'contained database authentication', 1; GO RECONFIGURE; GO Step 2: USE master; GO ALTER DATABASE [Geodaten] SET CONTAINMENT = PARTIAL; GO Step 3: USE Geodaten; GO CREATE USER testgis1 WITH PASSWORD = 'password'; GO ALTER ROLE db_owner ADD MEMBER testgis1; GO The user is created in the Geodaten database. However, when I try to connect to the database using MS SQL Studio, I receive an error message (Error: 18456). Best regards Niko2KViews0likes1CommentUser management for a specific database
As a newcomer to MS SQL Server, I'm having trouble giving the user 'gis' with login the ability to create additional users in a specific database T and assign permissions (which I have already accomplished). At the same time, the user should not be able to see or modify other databases' users (or logins). Here are some additional details: 'sa' is the owner of the T database The 'gis' user has already been created as a user of the T database and is a member of the db_owner role 'gis' is the owner of the 'gisdaten' schema (of the database T) Any help or guidance would be greatly appreciated!2.3KViews0likes4Comments
Recent Blog Articles
No content to show