2.REVOKE 回收權(quán)限
REVOKE CONNECT, RESOURCE FROM 用戶名;
REVOKE SELECT ON 表名 FROM 用戶名;
REVOKE SELECT, INSERT, DELETE ON表名 FROM 用戶名1, 用戶名2;
查詢數(shù)據(jù)庫(kù)中第63號(hào)錯(cuò)誤：
select orgaddr,destaddr from sm_histable0116 where error_code='63';
查詢數(shù)據(jù)庫(kù)中開(kāi)戶用戶最大提交和最大下發(fā)數(shù)： select MSISDN,TCOS,OCOS from ms_usertable；
查詢數(shù)據(jù)庫(kù)中各種錯(cuò)誤代碼的總和：
select error_code,count(*) from sm_histable0513 group by error_code order
by error_code;
查詢報(bào)表數(shù)據(jù)庫(kù)中話單統(tǒng)計(jì)種類查詢。
select sum(Successcount) from tbl_MiddleMt0411 where ServiceType2=111
select sum(successcount),servicetype from tbl_middlemt0411 group by servicetype
本新聞共
8頁(yè),當(dāng)前在第
8頁(yè)
1 2 3 4 5 6 7 8 
