Geek asks and answers

What is the role of the ADSSYS user automatically created in the Advantage data dictionary?

When you create a data dictionary in Advantage Database Server (Sybase), the system automatically creates a user named ADSSYS. What is the role of this user, and can we remove it from our applications?

+3
source share
1 answer

From Advantage Help:

All Advantage data dictionaries contain an administrative user called ADSSYS. This user has permissions to perform any operation or update on the dictionary. Be aware that if the ADSSYS password is lost, it cannot be recovered or reset

I don’t think you can delete the user, just set a secure password, it acts like an administrator account.

You can specify any username in your application. If you connect as ADSSYSor an empty username, the user will be used ADSSYS. Of course, the connection will fail if this password is incorrect.

: ADSSYS.

http://devzone.advantagedatabase.com/dz/webhelp/advantage9.0/server1/advantage_data_dictionary_user_permissions.htm

http://devzone.advantagedatabase.com/dz/content.aspx?Key=17&SearchKeyWords=adssys

+4

More articles:


All Articles