Hi
I want to get the ddl of the priveleges of the user.
The script returns more than 100 rows hence I want to put ';' at the end of each line so i can run it in sqlplus.
How can I put ';' at the end of each line ?
SQL> select dbms_metadata.get_granted_ddl( 'OBJECT_GRANT', 'APPS' ) from dual where rownum<5;
DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','APPS')
--------------------------------------------------------------------------------
GRANT EXECUTE ON "SYS"."DBMS_LOCK" TO "APPS"
GRANT SELECT ON "SYS"."AQ$_UNF