Views & Authorisation

Question 1

What parts of the database can have different authorisations on them?

Answer 1

• Select
• Insert
• Update
• Delete
• Execute
• Create
• Alter
• Drop

Question 2

What commands are used to change a user’s privileges

Answer 2

grant or revoke

Question 3

How do we give users on a remote host access?

Answer 3

‘username’@’%’

Gives user access on any host

Question 4

How do you allow users to pass on authority?

Answer 4

after user list put ‘with grant option’ command.

Question 5

What does restrict do?

Answer 5

Prevents revoking of rights if cascading revokes are required.

Question 6

What are the selectors for parts of a database to apply the rights on?

Answer 6

. => all of the databases
test_db.* => all tables in the database test_db
test_db.person => person table in test_db
(person.id) on test_db.person => id column in person