Question Re: ASE 16 encrypted database in Technology Q&A

ASE 16 encrypted database

jmtorres — Tue, 04 Apr 2017 20:58:49 GMT

Hello,

When using the new SAP ASE 16 full encrypted database option:

-I assume that decrypt permission should be granted to a user/group ?

Thank you

Regards

Jose

gopal_ankitha — Fri, 14 Apr 2017 07:01:22 GMT

Hi Jose,

There is no need for you to grant the decrypt permission to a user or group.

Best Regards,

Ankitha

SAP Product Support

jmtorres — Mon, 17 Apr 2017 13:55:44 GMT

Thank you Ankitha,

So how can access to data can be restricted.?

For example:

assuming db_1 is encrypted then

t1 has 5 cols, cols #1 to #4 can be accessed by user_1, but col#5 not.

Thank you

Jose

former_member89972 — Mon, 17 Apr 2017 15:59:20 GMT

Jose

Use grants for table + column or create views specific to group of users.

Column level grants :

grant select on t1 (col#1, .... col#4) to user_1

Using View

Create view vw_4_user_1 as select col#1, ... col#4 from t1.

Then grant access to user_1 on this view.

Grant select on vw_4_user_1 to user_1.

Avinash

jmtorres — Mon, 17 Apr 2017 16:05:40 GMT

Thanks a lot Avinash.

So in the end, if I use encrypted cols option I can use both features in case needed?(db+col encryption)

Jose.