User

A name for an actor (person or system) that makes a connection with the SQLstream s-Server. s-Server supports two types of users. The default user, created on installation, is the administrator user. This user can create non-administrator users. These users do not have access to any system tables or functions (even in non-sandboxed environments). When s-Server is run in sandboxed mode, non-administrator users are denied the following privileges:

  • The creation of any Java-based user defined function, user defined procedure, or user defined transform unless these refer to a Java function that is annotated with the @AllowedInSandbox annotation.
  • The execution of the commands ALTER SYSTEM, ALTER SESSION, CREATE JAR, IMPORT FOREIGN SCHEMA, CREATE USER, CREATE SERVER, CREATE FOREIGN STREAM, and CREATE FOREIGN TABLE.
  • Direct access to imported schemas in the SYS_BOOT catalog.