Specifying a Schema User

You must provide a login name for the user to whom you want to grant access to the bit9_public schema.

Use the following script to add this login name and login manually (after the Carbon Black App Control Server is installed). Replace Domain and cbprotectionuser with your own values for the appropriate Windows user.

CREATE LOGIN [Domain\cbprotectionuser] FROM WINDOWS WITH DEFAULT_DATABASE=[Das] GO CREATE USER [Domain\cbprotectionuser] FOR LOGIN [Domain\cbprotectionuser] GO USE [Das] GO GRANT SELECT ON SCHEMA :: dbo TO [Domain\cbprotectionuser] GO GRANT EXECUTE ON SCHEMA :: dbo TO [Domain\cbprotectionuser] GO ALTER AUTHORIZATION ON SCHEMA::bit9_public TO [Domain\cbprotectionuser] GO

CREATE LOGIN [Domain\cbprotectionuser] FROM WINDOWS WITH DEFAULT_DATABASE=[Das] 
                        GO 
                        CREATE USER [Domain\cbprotectionuser] FOR LOGIN 
                        [Domain\cbprotectionuser] 
                        GO 
                        USE [Das] 
                        GO 
                        GRANT SELECT ON SCHEMA :: dbo TO 
                        [Domain\cbprotectionuser]
                        GO 
                        GRANT EXECUTE ON SCHEMA :: dbo TO 
                        [Domain\cbprotectionuser]
                        GO 
                        ALTER AUTHORIZATION ON SCHEMA::bit9_public TO 
                        [Domain\cbprotectionuser]
                        GO