SQL Server·þÎñÆ÷½ÇÉ«ÓëÊý¾Ý¿â½ÇÉ«Çø±ð
¹Ì¶¨·þÎñÆ÷½ÇÉ«
sysadmin ¿ÉÒÔÔÚ SQL Server ÖÐÖ´ÐÐÈκλ¡£
serveradmin ¿ÉÒÔÉèÖ÷þÎñÆ÷·¶Î§µÄÅäÖÃÑ¡Ï¹Ø±Õ·þÎñÆ÷¡£
setupadmin ¿ÉÒÔ¹ÜÀíÁ´½Ó·þÎñÆ÷ºÍÆô¶¯¹ý³Ì¡£
securityadmin ¿ÉÒÔ¹ÜÀíµÇ¼ºÍ CREATE DATABASE ȨÏÞ£¬»¹¿ÉÒÔ¶ÁÈ¡´íÎóÈÕÖ¾ºÍ¸ü¸ÄÃÜÂë¡£
processadmin ¿ÉÒÔ¹ÜÀíÔÚ SQL Server ÖÐÔËÐеĽø³Ì¡£
dbcreator ¿ÉÒÔ´´½¨¡¢¸ü¸ÄºÍ³ýÈ¥Êý¾Ý¿â¡£
diskadmin ¿ÉÒÔ¹ÜÀí´ÅÅÌÎļþ¡£
bulkadmin ¿ÉÒÔÖ´ÐÐ BULK INSERT Óï¾ä¡£
·þÎñÆ÷½ÇÉ«ÊÇÕë¶Ô·þÎñÆ÷Õâ¸ö²ã´ÎµÄȨÏÞ¶øÑÔµÄ,Ò²¾ÍÊÇ˵һ°ã¼ÓÈëµ½·þÎñÆ÷½ÇÉ«ÀïµÄÓû§¶¼ÊǾßÓжԷþÎñÆ÷Ò»¶¨µÄ¹ÜÀíȨÏÞ
Êý¾Ý¿â½ÇÉ«
db_owner ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÖ´ÐÐÊý¾Ý¿âµÄËùÓÐÅäÖúÍά»¤»î¶¯£¬»¹¿ÉÒÔɾ³ýÊý¾Ý¿â¡£
db_securityadmin ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÐ޸ĽÇÉ«³ÉÔ±Éí·ÝºÍ¹ÜÀíȨÏÞ¡£Ïò´Ë½ÇÉ«ÖÐÌí¼ÓÖ÷Ìå¿ÉÄܻᵼÖÂÒâÍâµÄȨÏÞÉý¼¶¡£
db_accessadmin ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔΪ Windows µÇ¼Ãû¡¢Windows ×éºÍ SQL Server µÇ¼ÃûÌí¼Ó»òɾ³ýÊý¾Ý¿â·ÃÎÊȨÏÞ¡£
db_backupoperator ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔ±¸·ÝÊý¾Ý¿â¡£
db_ddladmin ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÔÚÊý¾Ý¿âÖÐÔËÐÐÈκÎÊý¾Ý¶¨ÒåÓïÑÔ (DDL) ÃüÁî¡£
db_datawriter ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÔÚËùÓÐÓû§±íÖÐÌí¼Ó¡¢É¾³ý»ò¸ü¸ÄÊý¾Ý¡£
db_datareader ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔ´ÓËùÓÐÓû§±íÖжÁÈ¡ËùÓÐÊý¾Ý¡£
db_denydatawriter ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±²»ÄÜÌí¼Ó¡¢Ð޸Ļòɾ³ýÊý¾Ý¿âÄÚÓû§±íÖеÄÈκÎÊý¾Ý¡£
db_denydatareader ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±²»ÄܶÁÈ¡Êý¾Ý¿âÄÚÓû§±íÖеÄÈκÎÊý¾Ý¡£
Êý¾Ý¿â½ÇÉ«ÊÇÕë¶ÔÊý¾Ý¿â²ã´Î¶øÑԵģ¬Óû§¼ÓÈ뵽ij¸öÊý¾Ý¿âµÄÊý¾Ý¿â½ÇÉ«Öкó,Õâ¸öÓû§Ö»ÊÇÔÚÕâ¸öÊý¾Ý¿âÀïÃæ¾ßÓÐÔÚ½ÇÉ«ÀïÖ¸¶¨µÄÓû§È¨ÏÞ¡£
Ò»¸öÓû§µÄ×îÖÕȨÏÞÊÇÓÉ ·þÎñÆ÷½ÇÉ«ÓëÊý¾Ý¿â½ÇÉ«×é³ÉµÄ
Ïà¹ØÎĵµ£º
ǰ¶Îʱ¼äѧµÄÓйØsqlµÄÏà¹ØÖªÊ¶,ºÜ¶à¶¼Ã»¼°Ê±È¥ÕûÀí,½ñÌì¸ÕºÃÓÐʱ¼äÓÐûÐÄÇé×öÆäËûµÄÊÇ,¾ÍÕûÀíÕûÀí°É
Ò»Ö±ÒÔΪ×ö¿ª·¢µÄ¶ÔÊý¾Ý¿â²Ù×÷·½ÃæµÄÒªÇó²»»áºÜ¸ß,Ö»Òª»á¶ÔÊý¾ÝÔöɾ¸Ä²é¾ÍokÁË.ÏÖÔÚ²ÅÖªµÀ¶ÔÊý¾Ý¿âµÄ²Ù×÷»¹Ó¦¸Ã°üÀ¨Ð´´æ´¢ºÍº¯Êý,»¹Òª´´½¨ÐòÁС¢Ë÷Òý,ÊÓͼµÈ.
......
¿ÉÀ©Õ¹ÐԸĽø¡¡¡¡½èÖúÓÚÐÂÓ²¼þÉ豸¶ÔÓÚÆóÒµ°æWindows Server 2008 R2µÄÔöÇ¿£¬SQL Server2008R2½«ÄÜÖ§³Ö¸ß´ï56¸öÂß¼´¦ÀíÆ÷ºÍ2TBÄÚ´æ¡£ÕâЩ¹¦ÄܵÄÔöÇ¿½«Ê¹µÃÆóÒµÄÜ´¦Àí¸ü¼Ó¾Þ´óµÄ¸ºÔØÁ¿£¬²¢ÄÜÔö¼Ó¿ÉÒÔͳһµ½Ò»¸öƽ̨ÉϵķþÎñÆ÷£¬ÊµÀýºÍÊý¾Ý¿âµÄÊýÁ¿¡£
¡¡¡¡ÕûºÏ¹¤¾ß
¡¡¡¡¶ÔÓÚSQLServer2008» ......
Ò», °²×° unixODBC
ÏÂÔØ°²×°°ü. ÔÚ RedHat °²×°¹âÅÌÉϾÍÓÐ
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
°²×°
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
Èç¹û°²×°ÖÐÌáʾÓÐ¶ÔÆäËü° ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[sp_GetRecordfromPage]
@TableName varchar(350), --±íÃû
@Fields varchar(5000) = '*', --×Ö¶ÎÃû(È«²¿×Ö¶ÎΪ*)
@OrderField varchar(5000), &nbs ......
bigint ´Ó -2^63 (-9223372036854775808) µ½ 2^63-1 (9223372036854775807) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£ Int64
int ´Ó -2^31 (-2,147,483,648) µ½ 2^31 - 1 (2,147,483,647) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer¡£ Int32
smallint ´Ó -2^15 (-32,768) µ½ ......