Views [dbo].[pubappca]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created6:13:12 PM Tuesday, May 05, 2009
Last Modified7:53:16 AM Monday, November 30, 2009
Columns
Name
swuuid
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script
CREATE  VIEW dbo.pubappca
        AS
        SELECT    swuuid
        FROM    ai_swdef_prop
            INNER JOIN ai_pubdef_prop
        ON    ai_swdef_prop.pubuuid = ai_pubdef_prop.pubuuid
        WHERE    pubname = 'Computer Associates International'
GO
GRANT SELECT ON  [dbo].[pubappca] TO [aiadmin]
GRANT INSERT ON  [dbo].[pubappca] TO [aiadmin]
GRANT DELETE ON  [dbo].[pubappca] TO [aiadmin]
GRANT UPDATE ON  [dbo].[pubappca] TO [aiadmin]
GRANT SELECT ON  [dbo].[pubappca] TO [aipublic]
GO
Uses
Used By