ASE 16 encrypted database

[jmtorres]

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

[jmtorres]

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]

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]

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.

[gopal_ankitha]

Hi Jose,

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

Best Regards,

Ankitha

SAP Product Support