Here is what RESTRICTED_USER does:
RESTRICTED_USER
allows for only members of the db_owner fixed database role and
dbcreator and sysadmin fixed server roles to connect to the database,
but does not limit their number. All connections to the database are
disconnected in the timeframe specified by the termination clause of
the ALTER DATABASE statement. After the database has transitioned to
the RESTRICTED_USER state, connection attempts by unqualified users are
refused.
RESTRICTED_USER allows for only members of the db_owner
fixed database role and dbcreator and sysadmin fixed server roles to
connect to the database, but does not limit their number. All
connections to the database are disconnected in the timeframe specified
by the termination clause of the ALTER DATABASE statement. After the
database has transitioned to the RESTRICTED_USER state, connection
attempts by unqualified users are refused.
Syntax is as follows:
alter database dbname
set RESTRICTED_USER
Be the first to rate this post
- Currently 0/5 Stars.
- 1
- 2
- 3
- 4
- 5