Progress
SQL-89
Guide and Reference
Access Privileges
To perform operations on tables and views, you must have the appropriate privileges. Privileges consist of a combination of objects (table, view, or column) and one or more operations. The operations are SELECT, INSERT, UPDATE, DELETE, and ALL PRIVILEGES.
The owner (creator) of a table automatically holds all privileges on that table. The owner’s privileges of a view depend on the privileges the view owner holds on the underlying tables and views. If the owner holds INSERT, UPDATE, and DELETE privileges on the underlying tables and views, and the view is updatable, then the owner holds those same privileges on the view. Otherwise, the owner holds only the SELECT privilege on the view.
As the owner of a table or view, you can grant privileges to other users using the GRANT statement. Using the WITH GRANT OPTION clause, you can allow the recipients of the privileges to grant those same privileges to other users. The owner and any user of the GRANT privilege can revoke privileges using the REVOKE statement. However, no privileges can be revoked from the owner.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |