Microsoft SQL Server Security issues _oracle

Source: Internet
Author: User
Tags microsoft sql server mixed
The Oracle tutorial you are looking at is Microsoft SQL Server security issues.
Microsoft SQL Server 7.0 Security issues

Microsoft Corporation

""microsoft SQL Server 7.0"hereinafter referred to as"sql server 7.0""

What are some of the security modes for SQL Server 7.0?

Two types: SQL Server and Windows NT (mixed) and Windows NT only. SQL Server and Windows NT are equivalent to the SQL Server 6.5 version of blending mode. Windows NT only corresponds to the SQL Server 6.5 version of trust mode. In SQL Server version 7.0, there is no standard mode equivalent to the version of SQL Server 6.5.

Why is SQL Server 6.5 's SQL Security Manager (Manger) missing from SQL Server 7.0, and what is the alternative?

SQL Server 7.0 provides a security Wizard (Wizard) to replace the SQL Security Manager (Manger).

What are the advantages of using SQL Server and Windows NT (mixed) security mode?

Non-Windows NT clients, Internet clients can also log on.
provides multi-layer protection.
What are the advantages of using Windows NT only security mode?

Users can log on to SQL Server more quickly without having to write another password.
Use NT-provided password settings, such as Minimum password length (minimum password length), ...
Set account and group settings for NT groups only.
How do I set the security mode for SQL Server?

Start SQL Server Enterprise Manager (Enterprise Manager).
In the console tree, expand Microsoft SQL Servers, and then expand SQL Server group or the group that you set up, and click to select the SQL Server you want to set up.
Right-click, select Properties, and then select the Security tab.
In the Security section, select SQL Server and Windows NT or Windows NT only.
How do I set up to allow a Windows NT group or user to log on to SQL Server in SQL Server Enterprise Manager?

In SQL Server Enterprise Manager, expand SQL Server that you want to join a Windows NT group or user account, expand the Security folder, select Login, and then right-click to select New Login on the shortcut menu.
Select the General tab and fill in the domain \ account number or domain \ Group in the Name field.
In the Authentication (authentication) section, select Windows NT Authentication (Windows NT Authentication), and then select Domain.
In the default section, select the preset database and language.
Click the OK button.
How do I use SQL Server stored procedures to enable a Windows NT group or user to log on to SQL Server?

sp_grantlogin {Login}
Where login contains domain and group/user accounts, no more than 128 characters.

What do you need to be aware of when you set up Windows NT groups or users to log on to SQL Server?

If SQL Server's login ID corresponds to a Windows NT group, users who add or remove Windows NT groups do not need to re-establish the login ID of SQL Server.
If SQL Server's login ID corresponds to a Windows NT group or user, removing this Windows NT group or user does not remove the SQL Server's login ID.
<

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.