Server Commands - ALTER SYSTEM Role

Alters the properties of an existing system user


ALTER SYSTEM ROLE <roleName> [SET POLICY <policyName ON <resource>]* [REMOVE POLICY ON <resource>]
  • <roleName> A system role name
  • <policyName> The name of a security policy
  • <resource> A database resource, eg. database.class.AClassName


  alter system role Foo  set policy bar on database.class.Person 
     set policy bar on database.class.Xx remove policy on database.class.Person

results matching ""

    No results matching ""