SQL Server

开发平台：

Unix_Linux

testIS3.sql：源码内容

							ALTER SCHEMA AUTHORIZATION INFORMATION_SCHEMA
CREATE VIEW COLUMNS
       AS ( SELECT
          COLNAME, UNTABID , COLNO, COLTYPE, DEFNULL
       FROM  DEFINITION_SCHEMA.SYSCOLUMNS
       WHERE UNTABID
             IN
              ( SELECT UNTABID
                FROM   DEFINITION_SCHEMA.SYSCOLAUTH          
                WHERE  GRANTEE
                       IN ( 'PUBLIC' , USER )
              )
       )
GRANT SELECT ON COLUMNS                 TO PUBLIC

						