How to restrict Images and Videos access in db_image and db_video table to particular set of Users.

[gurdesi2]

Hi there,

We need a suggestion over how to restrict access for our particular application images and videos stored in db_image and db_video table to only a set of required users. 

We are using these images in portal and want no one apart from set of user to access it in backend tables. 

Thanks.

[Martin Friedel]

Hello, 

I believe you can achieve it by creating ACL records:

As admin, elevate role to security_admin and open Access Controls table [sys_security_acl].

Create a new record.

• Type: record
• Operation: read
• Decision type: Deny Unless
• Name: Images [db_image]
• Applies to: Name of your application (as you mentioned images are part of your application, otherwise select other proper filter condition that meets your requirement)
• Condition: Depends on your requirement. For example if all users are in the same group, you can choose condition Group is <group name>

Create same ACL for Videos table [db_video].

If my answer helped you, please mark it as correct and helpful, thank you 👍
Martin

[Ankur Bawiskar]

@gurdesi2 

you can use table level READ ACL on db_image and the other table

what did you start with and where are you stuck?

If my response helped please mark it correct and close the thread so that it benefits future readers.