Question Dump/load - SQL privileges

[ron]

OE 10.2 - RH Linux

I've dumped/reloaded many DBs before - but this is my first try with an OE DB that only contains SQL tables.

I had many problems, but got through all except one. My final DB (in testing) is missing some SQL privileges.

In the original DB, when I display sequence privileges I see this:

GRANTOR GRANTEE SEQ-OWNER SEQ-NAME UPD REF SEL
----------- ------------ ---------- --------- --- --- ---
ron ron pub chqs g g
ron ron pub psli g g
ron helen pub psli y y

But in the new DB there is nothing. So, two questions: (1) what did I miss? and (2) I can manually repair this by granting select,update on the sequences - but that just gives me a "y". What is the "g"? Is it the privilege to grant? Anyway - how do I grant that (ie, the "g")?

 

[TheMadDBA]

This KB covers how to dump and load the various SQL grants http://knowledgebase.progress.com/articles/Article/P17829

"y" means they have that privilege... I "think" g means they have been granted dba access.

 

[Rob Fitzpatrick]

I thought "g" meant grantor privilege but I could be wrong.

 

[TheMadDBA]

It might indeed be. Documentation is seemingly non existent on that column and I never let any other users grant privileges