In a database where no users have been created within the database _user table no password is necessary to connect to the database.
Any text value may be supplied for the password and the connection to the database would be allowed because there is no authentication check at this time.
Authentication is only enabled when users are created in the _user table. If there are no users in the database, there is no authentication check performed when connecting. However, if a user other than the DBA connects, this user has access only to public tables or tables where a DBA has granted privileges to the user.
NOTE: Privileges can be granted even when there are no users created in the database. If users are added to the _user table they must be granted privileges from the SQL side by a DBA account in order to work with data from the SQL side. Failure to do so will result in queries returning error 7512.
To enable Authentication, create at least one user in the database.
Always grant DBA access to at least one user of the database.
When users are created in the database, the default DBA (the user who created the database) becomes disabled. It is important to grant DBA access to at least one user so you will have a valid DBA account.
In the event that at least one user was created but DBA access rights are not given, this user can create a sysprogress user via the 4GL Data Administration Tool to allow DBA access to the database.
Make sure that password is defined for sysprogress user or connection will fail. |
