Previous Topic

Next Topic

Book Contents

Book Index

Authorities: database-type specific notes

DB2 notes

SQL Server notes

Sybase Enterprise notes

Sybase will not record that a user has access to a table, if this access has already been granted to the user's group.

For instance, if:

This can be confusing for the novice DBA!

Informix notes

You cannot grant authorities on objects owned by someone other than yourself, unless you use the Grantor option. The Grantor option can only be done by a user with DBA authority.

If you try and grant authority on another user's tables, you will get the message No GRANT option or illegal option on multi-table view (which, in our opinion, doesn't describe what the problem is).

Pervasive.SQL notes