Create or re-create a user, either from scratch or as a copy of another user. Users can be created to log in using Essbase security, or to use external authentication using an outside authentication protocol. Optionally create the Essbase-authenticated user as a member of a group. Permission required: create_user.
create user Fiona identified by sunflower;
Creates a user called Fiona with the password sunflower.
create user Guest identified by 'password' member of group Visitors;
Creates a user called Guest with the password password, and adds Guest to the group called Visitors. Quotation marks are required because password is a MaxL keyword.
create or replace user Guest identified by 'password' as RecycleMe;
Creates a user called Guest as a copy of an existing user called RecycleMe. If Guest already exists, it is overwritten.
create or replace user 'Autumn Smith' type external;
Creates a user called Autumn Smith who is externally authenticated in a corporate authentication repository supported by the Hyperion security platform: either LDAP, Microsoft Active Directory, or Windows NT LAN Manager.
create or replace user Fred type external with protocol 'LDAP' identified by 'cn=Engineers, ou=Groups, dc=yahoo, dc=com@server2';
Creates a user called Fred who is externally authenticated with the Lightweight Directory Access Protocol. This authentication module is not the Hyperion security platform; it is a custom Essbase .dll
, retained for backward compatibility.
Use create user to create a user in the following ways:
Key Phrase | Explanation |
---|---|
create user | Create a new Essbase user. |
create or replace user | Create a new Essbase user. If a user of that name already exists, it is replaced. |
create user as | Create a user as a copy of an existing user. The new user has an identical security profile to the user that was copied. |
member of group | Create a user and assign membership to a security group. |
comment | Create an optional comment to describe the user. |
type external | Skipping the protocol and parameters, create a user that must log in using the Hyperion security platform. In order for the user to be able to log in successfully,
the AUTHENTICATIONMODULE parameter must be set to CSS in the essbase.cfg file, and
the name must match a valid user name in the external authentication repository. |
type external with protocol... | Create a user that must log in using a custom Essbase external-authentication method, such as LDAP, instead of the standard Essbase login security. Not applicable for the Hyperion security platform. |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |