SQL Privileges

[casorohi]

I am running the following command on OE102B @ linux to dump the SQL Privileges/dump
sqlschema -u <username> -a <password> -g <ownername>.<table name> -o <outputfile> progress:T:<hostname>:<portname>:<database name>
It is working fine for one table with -g pub.<table name>
I want to dump the SQL privileges for whole DB
what values should be to dump for whole DB in shot/line “ -g <???>.<???> "

thnx

 

[cj_brandt]

Have you tried sqlschema with a -t %.% instead of -g. The % works as a wild card.

I use it like -t PUB.% - all tables owned by the PUB schema.