Adds a new SAP Sybase IQ user account to the specified login policy.
call sp_iqaddlogin (‘username_in’, ‘pwd’, [ ’password_expiry_on_next_login ’] [ , ’policy_name ’] )
A username_in/pwd created using sp_iqaddlogin and set to expire in one day is valid all day tomorrow and invalid on the following day. In other words, a login created today and set to expire in n days are not usable once the date changes to the (n+1)th day.
You must have EXECUTE privilege on the system procedure, as well as the MANAGE ANY USER system privilege..
Adds a new SAP Sybase IQ user account, assigns a login policy to the user and adds the user to the ISYSUSER system table. If the user already has a user ID for the database but is not in ISYSUSER, (for example, if the user ID was added using the GRANT CONNECT statement or SAP Control Center), sp_iqaddlogin adds the user to the table.
If you do not specify a login policy name when calling the procedure, SAP Sybase IQ assigns the user to the root login policy.
The first user login forces a password change and assigns a login policy to the newly created user. Use CREATE USER to create new users, although, for backward compatibility, sp_iqaddlogin is still supported.