Funnily enough, I had to do this only yesterday. In Oracle you do:
begin
acs_permission.grant_permission (
object_id => acs.magic_object_id('security_context_root'),
grantee_id => :user_id,
privilege => 'admin'
);
end;
and in Postgres it's:
select acs_permission__grant_permission(
acs__magic_object_id('security_context_root'),
:user_id,
'admin')
(from
/packages/acs-bootstrap-installer/installer/create-administrator-2.tcl)