2.3.2 Altering a Profile

Table of Contents Previous Next


2 SQL Tutorial : 2.3 Profile Management : 2.3.2 Altering a Profile

Use the ALTER PROFILE command to modify a user-defined profile; Advanced Server supports two forms of the command:
ALTER PROFILE profile_name RENAME TO new_name;
ALTER PROFILE profile_name
LIMIT {
parameter value}[...];
Include the LIMIT clause and one or more space-delimited parameter/value pairs to specify the rules enforced by Advanced Server, or use ALTER PROFILERENAME TO to change the name of a profile.
profile_name specifies the name of the profile.
new_name specifies the new name of the profile.
parameter specifies the attribute limited by the profile.
value specifies the parameter limit.
See the table in Section 2.3.1 for a complete list of accepted parameter/value pairs.
acctg_profile will count failed connection attempts when a login role attempts to connect to the server. The profile specifies that if a user has not authenticated with the correct password in three attempts, the account will be locked for one day.
The following example changes the name of acctg_profile to payables_profile:

2 SQL Tutorial : 2.3 Profile Management : 2.3.2 Altering a Profile

Table of Contents Previous Next