Enabling database inheritance
By default, inherited privileges are enabled at the database level, through configuration parameter disableinheritedprivileges.
By default, inherited privileges are enabled at the database level, through configuration parameter disableinheritedprivileges
. To enable inherited privileges:
=> ALTER DATABASE [database name] SET disableinheritedprivileges = 0;
To disable inherited privileges:
=> ALTER DATABASE [database name] SET disableinheritedprivileges = 1;