Wrong database permissions - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Wrong database permissions

Author

Topic

alucas2406
Starting Member

3 Posts

Posted - 2014-06-20 : 04:22:06

Hi, when creating a new database in the security a domain group is added that doesn't exists any more on the server
I am playing with creating different security groups for different sorts of users that needs to access the database

below the reports from

SELECT * FROM sys.server_principals

SELECT * FROM sys.database_principals

sa
public
sysadmin
securityadmin
serveradmin
setupadmin
processadmin
diskadmin
dbcreator
bulkadmin
##MS_SQLResourceSigningCertificate##
##MS_SQLReplicationSigningCertificate##
##MS_SQLAuthenticatorCertificate##
##MS_PolicySigningCertificate##
##MS_SmoExtendedSigningCertificate##
##MS_PolicyTsqlExecutionLogin##
HST-AMS\Administrator
NT SERVICE\SQLWriter
NT SERVICE\Winmgmt
NT SERVICE\MSSQLSERVER
NT AUTHORITY\SYSTEM
NT SERVICE\SQLSERVERAGENT
##MS_PolicyEventProcessingLogin##
##MS_AgentSigningCertificate##
HST-AMS\sql admin test

public
dbo
guest
INFORMATION_SCHEMA
sys
HST-AMS\SQL Admins
db_owner
db_accessadmin
db_securityadmin
db_ddladmin
db_backupoperator
db_datareader
db_datawriter
db_denydatareader
db_denydatawriter

the group HST-AMS\SQL Admins in my opinion isn't in the security of sql but is added to the database security

What am I missing here

Regards
An SQL newbie

alucas2406
Starting Member

3 Posts

Posted - 2014-06-20 : 07:40:48

Hi Fixed it myself

Added the HST\SQL Admins again to SQL users
Noticed that there where two databases it had dbo rights on
model and MSDB removed the credentials for the databases and deleted group again

Now new databases are created without the above group connected to it

Regards Andre

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources