You are the administrator of a SQL Server 2008 instance.
There is a Windows group named Wiikigo\Service. According to the security policy, members of this group are allowed to set up new connections to the SQL Server instance.
But this is can only be done during office time from 8:00-20:00.
Other users may connect to the SQL Server instance any time.
You write the following Transact-SQL statements:
CREATE TABLE Security.RestrictedLogonHours (
Id in NOT NULL IDENTITY(1,1),
GroupName sysname NOT NULL,
RestrictedTimeStart time NOT NULL,
RestrictedTimeStop time NOT NULL,
CONSTRAINT RestrictedLogonHours_pk
PRIMARY KEY CLUSTERED(Id)
);
INSERT INTO Security.RestrictedLogonHours (
GroupName,
RestrictedTimeStart,
RestrictedTimeStop
)
VALUES (
'CONTOSO\Sales',
CAST('07:00' AS time),
CAST('19:00' AS time)
);
You need to implement the company security policy which is stored in the RestrictedLogonHours table.
What should you do?
Selecciona una de las siguientes respuestas posibles: