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
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|