Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÓÃODBCÁ¬½ÓOracleÊý¾Ý¿â - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚOracleÖн¨Á¢ÁËÒ»¸östudent±í£¬È»ºóÏÖÔÚÔÚvcÖвÙ×÷£¬¿ÉÊÇÔÚvcµÄÏòµ¼ÖÐÓöµ½ÁËÎÊÌ⣬ÔÚDatabase optionsÖÐODBCÎÒÑ¡ÔñÁËorcl£¬recordset typeÑ¡ÔñÁËdynaset£¬ÎÒµ¥»÷okºóµ¯³öOracle ODBC driver connect¶Ô»°¿òuser nameдsysÔõô¶¼Ã»ÓÃÓÚÊÇÎÒ×Ô¼ºÔÚ´´½¨ÁËÒ»¸öÓû§lijin£¬½øÈëµ½select database tables¶Ô»°¿òÖУ¬ÔÚÕâ¸ö¶Ô»°¿òÖоÓÈ»ÕÒ²»µ½studentÕâ¸ö±í£¬¸ßÈËÖ¸µãÒ»ÏÂÒªÔõô×ö£¿£¿£¿
Èç¹û¿ÉÒÔÕý³£Á¬½Óµ½Êý¾Ý¿â
ÐèҪʹÓÃschema À´·ÃÎÊÊý¾Ý¿â¡£
Æä´ÎÊÇ·ñ¶Ô¸ÃÓû§ÊÚÓèÁËselect ȨÏÞ

grant select on schema.talbename to lijin

½øÈëµ½select database tables¶Ô»°¿òÖУ¬ÔÚÕâ¸ö¶Ô»°¿òÖоÓÈ»ÕÒ²»µ½studentÕâ¸ö±í,¾ÍÊÇÕâ¸ö²»ÖªµÀ¸ÃÔõô°ì°¡

ͬһ¥£¬¾õµÃÓ¦¸ÃÊÇȨÏÞÎÊÌâ

ÎÒÔÚÃüÁîÖмÓÁËÕâÌõÃüÁîGRANT UNLIMITED TABLESPACE TO "linjin"°ÑËùÓбí¿Õ¼äµÄʹÓÃȨ¶¼¸ølijin£¬¿ÉÊǽøÈëµ½select database tables¶Ô»°¿òÖУ¬»¹ÊÇÕÒ²»µ½studentÕâ¸ö±í£¬ÀïÃæ¸ü±¾¾ÍûÓÐlijinÕâ¸öÓû§´æÔÚ¡£µ½µ×ÒªÔõô×ö°¡£¬Äܲ»ÄÜÏêϸµã

grant select anytable to lijin

ÒýÓÃ
grant select anytable to lijin

ÄãÕâ¸öÓï¾äû·¨Ö´ÐУ¬ÌáʾȨÏÞȱʧ»òÎÞЧ¡£

ÓÃusername/password as sysdbaµÇ½
grant select on table to user1;

ÎÒÔÚOracleÖн¨Á¢ÁËÒ»¸östudent±í£¬È»ºóÏÖÔÚÔÚvcÖвÙ×÷£¬¿ÉÊÇÔÚvcµÄÏòµ¼ÖÐÓöµ½ÁËÎÊÌ⣬ÔÚDatabase optionsÖÐODBCÎÒÑ¡ÔñÁËorcl£¬recordset typeÑ¡ÔñÁËdynaset£¬ÎÒµ¥»÷okºóµ¯³öOracle ODBC driver connect¶Ô»°¿òuser nameдsysÔõô¶¼Ã»ÓÃÓÚÊÇÎÒ×Ô¼ºÔÚ´´½¨ÁËÒ»¸öÓû§lijin£¬½øÈëµ½select database tables¶Ô»°¿òÖУ¬ÔÚÕâ¸ö¶Ô»°¿òÖоÓÈ»ÕÒ²»µ½studentÕâ¸ö±í£¬¸ßÈË


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

¹ØÓÚOracle´¥·¢Æ÷µÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡
×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½
´¥·¢Æ÷?
Ó¦¸ÃÓÃJOB

Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí

ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......

Çë½ÌÒ»¸öoracle¹ÜÀíµÄÎÊÌ⣡ - Oracle / »ù´¡ºÍ¹ÜÀí

·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ