开发者

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

开发者 https://www.devze.com 2023-03-03 05:27 出处:网络
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

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

0

精彩评论

暂无评论...
验证码 换一张
取 消