Hi All,

Is der anyway of granting select privledge to schema.My database contains many tables and i need to grant select privledge to a user who want to run reports.
o
r
Will "grant select on tab1,tab1..list to user1,user2", I mean granting select privledges to multi-tables at a time supported in IDS-7.3
Any assistance is greatly appreciated...

Thanks
Mallik

try something like this:

select "grant select on "|| tabname || " to user user1;"
from systables where tabid>99

And output from this sql run as sqlscript.