Grant on all tables

[ChristophFritz]

Hi @all,

in an maxDB which is installed with an SAP J2EE Engine after the installation there is one schema, called SAP<SID>, where <SID> is the System identifier.

All Tables in this schema belong the user SAP<SID>DB, who has Full read/write access on everry table. Now different Applications should run within the J2EE Engine. Therefor this Applikation needs read access to all the tables which belong the SAP<SID>DB User and write Access to its own table.

Is it possible to define an SQL Statement which grants read access to all tables, where the User SAP<SID>DB is the owner?

Furthermore the same user additionally should have write access to tables beginning with a special pattern (e.g. SAP<SID>.Z_PROJEKT1_*)

Regards

Christoph

[alexander_schroeder]

Hello Christoph,

unfortunately for you, there is no specific GRANT command for granting rights on the content of a complete schema to some user/usergroup/role.

So, you will need to write a small program, which access the catalog and then executes GRANT statements for each

table you want to access. If you use JDBC, the DatabaseMetaData.getTables() method is a good starting point for getting the needed table names.