Microsoft SQL Server Security Questions
Microsoft SQL Server Security Questions
The ORACLE tutorial is about Microsoft SQL Server Security.
Microsoft SQL Server 7.0 security questions
Microsoft Corporation
[Microsoft SQL Server 7.0, hereinafter referred to as "SQL Server 7.0 」]
Which security modes are available for SQL Server 7.0?
Two types: SQL Server and Windows NT (hybrid) and Windows NT only. SQL Server and Windows NT are equivalent to the hybrid mode of SQL Server 6.5. Windows NT only is equivalent to the trust mode of SQL Server 6.5. The standard mode equivalent to SQL Server 7.0 is not provided in SQL Server 6.5.
Why does the SQL Security Manager (Security Manger) of SQL Server 6.5 disappear in SQL Server 7.0? What is the alternative tool?
SQL Server 7.0 provides the Security Wizard to replace the Security manager ).
What are the advantages of SQL Server and Windows NT (hybrid) security mode?
You can also log on to an Internet client other than a Windows NT client.
Provides multi-layer protection.
What are the advantages of Windows NT only security mode?
You can log on to SQLServer more quickly without having to remember another password.
Use the password setting function provided by NT, such as the minimum password length (minimum password length ),..
You only need to set accounts and groups for the NT group.
How to set the Security Mode of SQL Server?
Start SQL Server Enterprise Manager ).
In the console tree, expand Microsoft SQL Servers, expand SQL Server Group or the Group you set, and click Select the SQL Server to be set.
Right-click Properties and select Security tab.
In the Security Section, select "SQL Server and Windows NT" or "Windows NT only ".
In SQL Server Enterprise Manager, how does one set to allow a Windows NT group or user to log on to SQL Server?
In SQL Server Enterprise Manager, expand the SQL Server to be added to the Windows NT group or user account, expand the Security folder, select login, right-click, and select new login from the shortcut menu.
Select the "General" tab and enter "domain \ account" or "domain \ group" in the Name field ".
In the Authentication section, select Windows NT Authentication (Windows NT Authentication), and then select domain ).
In the Default section, select the Default database and language.
Click OK.
How to Use the SQL Server stored procedure to enable a Windows NT group or user to log on to SQL Server?
Sp_grantlogin {login}
Login contains a domain, a group, or a user account, and cannot exceed 128 characters.
When setting a Windows NT group or logging on to SQL Server, what should I pay attention?
If the SQL Server logon id corresponds to a Windows NT group, you do not need to create a new SQL Server logon id to add or delete Windows NT groups.
If the logon id of SQL Server corresponds to a Windows NT group or user, deleting this Windows NT group or user does not delete the logon id of this SQL Server.
<
