Skip to Content
0
Former Member
Jan 29, 2009 at 06:58 PM

Create user with read access for all tables SAP<SID>.*

78 Views

Hello all,

could you please help me ? I would like to grant select privilege on all tables SAP<SID>.* for newly created user.

I have created standard database user (not exclusive).

I`m able to grant select for individual tables, but I would like to grant select for this user on all SAP<SID>

schema in simplier way 😊

But as far as I know, the schema`s owner name must be different then schema name.

Any idea please ?

Thank you.

Pavol