access rights

SiriDB knows the following access rights:

  • select
  • show
  • list
  • count
  • create
  • insert
  • drop
  • alter
  • grant
  • revoke

The most obvious ones are combined into access profiles which can be used to grant or revoke multiple access rights at once.

  • read: (select, show, list and count)
  • write: read + (create and insert)
  • modify: write + (drop and alter)
  • full: modify + (grant, revoke)

Warning

Changes to access rights are active immediately, so be careful when revoking access rights from users.