10 lines
460 B
SQL
10 lines
460 B
SQL
-- The MCP DB account owns the OCI GenAI planning functions while the game
|
|
-- catalog is owned by the data schema. Definer-rights PL/SQL needs direct
|
|
-- object grants; role grants are not sufficient at compile time.
|
|
BEGIN
|
|
EXECUTE IMMEDIATE 'GRANT SELECT ON SGMP_POC.SG_GAME_CATALOG TO ADMIN';
|
|
EXECUTE IMMEDIATE 'GRANT SELECT ON SGMP_POC.COMN_GAME_ALIAS_BAS TO ADMIN';
|
|
EXECUTE IMMEDIATE 'GRANT EXECUTE ON SGMP_POC.SG_GAME_CATALOG_SEARCH TO ADMIN';
|
|
END;
|
|
/
|