SQL/MX 3.1 Database and Application Migration Guide (H06.23+, J06.12+)

Removing Security Administrator Grants

HP NonStop SQL/MX Release 3.1 Database and Application Migration Guide—663853-001

A-3

objects.object_uid = grants.table_uid

and

cols.object_uid = grants.table_uid

and

(grants.column_number = -1 OR cols.column_number =

grants.column_number);

-- End Repeat for every catalog on the system...

-- Execute the following three statements only after repeating the above loop

-- for every catalog in the system...

log $$COMMANDS_FILE$$ clear;

select * from $$COMMANDS_TABLE$$;

log;

-- Exit mxci and logon as a security administrator.

-- Reenter mxci and obey the output file ($$COMMANDS_FILE$$) created above to

-- revoke the security administrator grants.

-- For example (and assuming $$COMMANDS_FILE$$ was set to “obey.txt”):

-- mxci

-- Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 3.1

-- >>obey obey.txt;