Create GRANT on condition

Asked

Viewed 30 times

0

I have a DRIVER table (columns: name, cnh, address, dots_wallet) and a GRANT analyst. The analyst can only access data from drivers who have more than 0 points in the wallet.

Grant select on conductor to analyst with GRANT OPTION;

how do I fit a WHERE enclosure or other thing that solves my problem?

mysql sql postgresql

  • And create a view and permission for the view, resolves?

  • I can try... but I was wondering if you could direct me?

  • 1

    I believe not, but will ...

  • would be the same as setting permissions for records, I think it is not possible. The best would be the same view

  • Postgres or Mysql? No postgres tem o row level security (https://www.postgresql.org/docs/9.5/static/ddl-rowsecurity.html), might help you

No answers

Browser other questions tagged mysql sql postgresql

You are not signed in. Login or sign up in order to post.