when selecting a table, can a user only see certain columns or rows, while a developer can access the rest of the table?
8/4/2017 12:04:54 AM
killerman642 Answers
New AnswerMySQL has built-in encryption, encoding, hashing and compression functions (these are separate and distinct). Views are often used for custom output displays Stored procedures can do scripty-like things You can indeed just give permission to columns Encrypted data is a requirement to meet credit card (etc) security standards. Guideline packs are well-written and freely available.
Oracle SQL also allows for hidden columns, but not hidden data within a visible column. as for encrypted, I have not seen anything natively encrypted by Oracle except for the ora hash, but I don't think that fits what you're asking.
Sololearn Inc.
535 Mission Street, Suite 1591Send us a message