Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » User security (roles and privileges)


Upgrading to role-based security

This chapter is intended for users of versions of SQL Anywhere prior to version 16.0. It explains changes when you upgrade your database to use role-based security, and what you may need to do if you have applications that execute SQL statements like the GRANT and REVOKE statements.

What happened to authorities, permissions, and groups?
Authorities become compatibility roles
Permissions become privileges
Groups are now achieved using roles
Change to concept of a super-user (DBA authority)
Changes to the GRANT statement syntax
Changes to the REVOKE statement syntax
Changes to REMOTE DBA
Changes in inheritance behavior for some authorities that became roles
Changes in administering the database publisher
Changes for system procedures that perform privileged operations