Flashcards
Views, privileges, security
Cards in this deck (5)
- 1WITH GRANT OPTIONThe WITH GRANT OPTION keywords convey the privilege or role to a user with the right to grant the same privileges or role to other users.
- 2A user has been granted "select ON X" by two different users. If one of them revokes the privilege by running: REVOKE select ON X FROM user Will the user have any privileges left?The user can still select on X.
A user that has received SELECT privileges on a table from more than one users can SELECT from that table until everyone who granted the permission revokes it. - 3If you use the CASCADE option when revoking a privilege, what will happen?the privilege will be revoked from all users which have been granted by this user.
- 4What is SQL injection? How can you prevent it?- A code injection technique which might destroy your database
Prevention (examples);
- always use prepared statements
-disallow multiple statements in your applications - 5—
Information
- Description
- Databas Flashcards on Views, privileges, security, created by Emma Tysk on 26/12/2017.
- Created by
- Emma Tysk
- Views
- 0
- Rating