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

SQL Server

开发平台:

Unix_Linux

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