LucidDbAppLib GRANT SELECT FOR SCHEMA

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Parameters 4 Example 5 Source Code

Syntax

CALL APPLIB.GRANT_SELECT_FOR_SCHEMA( schemaname, username )

Purpose

Grants a user SELECT privileges for all tables and views in a schema.

Parameters

• schemaname: name of schema containing tables and views to assign privs for [VARCHAR(255)]
• username: name of user to receive privileges [VARCHAR(255)]

Example

CALL APPLIB.GRANT_SELECT_FOR_SCHEMA( 'TESTSCHEMA', 'MONDRIAN_USER' )

(doesn't return anything)

Source Code

http://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/security/GrantSelectForSchemaUdp.java