DEV Community

loading...

Discussion on: Database Views Don't Really Exist

Collapse
robencom profile image
robencom

Nice article.

I have seen views being used as a way to not give SELECT privileges to some developers on a table containing "sensitive data".

That is kind of a smart use of it, isn't it?

Collapse
thatjoemoore profile image
Joseph Moore Author

I think so. Between views and stored procedures, you can do a lot in the way of granting least-privilege access in your database.