SQL security issues include which of the following?

Correct option is A

Granularity of administration is a critical aspect of SQL security as it determines how fine-tuned the access control is. It allows database administrators to define user roles, permissions, and privileges at various levels—database, table, column, or row—ensuring secure and restricted access to data.
Important Key Points:
1. Granularity of Administration: Enables fine-grained control over database objects and operations.
2. Key Security Practices: Includes role-based access control (RBAC) and granting/restricting permissions as needed.
3. Impact on Security: Higher granularity improves security by reducing unnecessary access.
Knowledge Booster:
· Complexity of Key Structures: While complex keys impact database performance, they are not directly related to security.
· Candidate Keys: These are potential primary keys but do not influence security measures.
· Size of Databases and Number of Records: These factors affect performance and storage, not security.
· Tools like Oracle Database Vault and SQL Server Role Management assist in implementing granular security controls.