What is the role of the ADSSYS user automatically created in an Advantage data dictionary?
When creating a data dictionary in Advantage Database Server (Sybase), the system automatically creates a user named ADSSYS开发者_高级运维. What's the role of this user, and can we remove it from our applications?
From the 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 remove 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 ADSSYS
or an empty username the ADSSYS
user will be used. Connection will of course fail if the given password is wrong.
Bottom line: Just set a secure password for the ADSSYS
user.
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
精彩评论