question

ClaudeVernier avatar image
ClaudeVernier asked

Dropped default schema by mistake, unexpected results, need help

Hello,

I dropped those default schema by mistake:

DROP SCHEMA [db_accessadmin]
DROP SCHEMA [db_backupoperator]
DROP SCHEMA [db_datareader]
DROP SCHEMA [db_datawriter]
DROP SCHEMA [db_ddladmin]
DROP SCHEMA [db_denydatareader]
DROP SCHEMA [db_denydatawriter]
DROP SCHEMA [db_owner]
DROP SCHEMA [db_securityadmin]

Now, my SQL users have the same access rights as db_owner as default !

I tried this for each but it didn't help :

DROP SCHEMA [*schemaName*]
GO
CREATE SCHEMA [*schemaName* ] AUTHORIZATION *db_role* 
GO


Any idea how I could fix this ?


Thanks,

Claude


sql server 2017schema
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.