testIS4.sql
上传用户:dgyhgb
上传日期:2007-01-07
资源大小:676k
文件大小:0k
源码类别:

SQL Server

开发平台:

Unix_Linux

  1. ALTER SCHEMA AUTHORIZATION INFORMATION_SCHEMA
  2. CREATE VIEW COLUMN_PRIVILEGES
  3.        AS ( SELECT
  4.           GRANTOR, GRANTEE, COLNO, UNTABID, COLAUTH
  5.        FROM   DEFINITION_SCHEMA.SYSCOLAUTH
  6.        WHERE   GRANTEE IN ('PUBLIC', USER )
  7.             OR GRANTOR = USER
  8.        )
  9. GRANT SELECT ON COLUMN_PRIVILEGES       TO PUBLIC