A privilege represents permission to perform a DML operation. Table lists the SQL privileges that can be granted and revoked.
Firebird SQL implements features for packaging multiple privileges for assignment to individual recipients, lists, or special groupings of users. One is the ALL package, another is comma-separated lists, and yet another is SQL roles.
The ALL Keyword
The ALL keyword packages the SELECT, INSERT, UPDATE, DELETE, and REFERENCES privileges in a single assignment. Roles and the EXECUTE privilege are not included in the ALL package.
Lists of Privileges
SELECT, INSERT, UPDATE, DELETE, and REFERENCES privileges can also be granted or revoked singly or in comma -separated lists. However, statements that grant or revoke either the EXECUTE privilege or a role cannot grant or revoke other privileges.
A role is created in a database and is available only to that database. Think of a role as a container for a bundle of privileges. Once the container is “filled” by having some privileges granted to it, it becomes available to be assigned —as a privilege—to some types of users.
Multiple roles can be created, the idea being to package and control discrete sets of privileges that can be granted and revoked as a whole, rather than as numerous collections of individual privileges being granted and revoked repetitively and in an adhoc fashion.
A role can never be granted as part of the ALL package, although a role can be granted ALL privileges.
Roles Are Not Groups
Roles are not like operating system user groups. A Firebird user can be assigned more than one role, but can log in under only one role in a session.
Firebird supports UNIX groups on POSIX platforms. If system-level authentication is implemented, you can grant privileges to UNIX groups. Refer to the TO GROUP <UNIX-group> option for GRANT and REVOKE.
Firebird Related Interview Questions
|RDBMS Interview Questions||MySQL Interview Questions|
|Linux Interview Questions||Mac OS X Deployment Interview Questions|
|Windows Administration Interview Questions||Windows Server 2003 Interview Questions|
|SQL Interview Questions||NoSQL Interview Questions|
|Advanced C++ Interview Questions|
Introduction To Client/server Architecture
About Firebird Data Types
Date And Time Types
Blobs And Arrays
From Drawing Board To Database
Creating And Maintaining A Database
Firebird’s Sql Language
Expressions And Predicates
Querying Multiple Tables
Ordered And Aggregated Sets
Overview Of Firebird Transactions In
Programming With Transactions
Introduction To Firebird Programming
Developing Psql Modules
Error Handling And Events
Security In The Operating Environment
Configuration And Special Features
Interactive Sql Utility (isql)
Database Backup And Restore (gbak)
Housekeeping Tool (gfix)
Understanding The Lock Manager
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.