Can we do GlideRecord or ACL Restriction on the Database View Record?

[rahulrockkk]

Hi Team,

Can we do GlideRecord to the Database view records so that i can copy and paste the record to the custom table? Or Can we write ACL restriction to the Database View Records?

Please check and provide your inputs.

@Ankur Bawiskar - Please provide your inputs for the above mentioned point.

[Ankur Bawiskar]

@rahulrockkk 

yes you can do GlideRecord, access field value and copy to other table

what did you start and where are you stuck?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[rahulrockkk]

Hi Ankur,

Thanks for the response. Can we write Read ACL on the database view records? If the answer is no- We are planning to copy the database view records to the custom table and then we need to implement the read ACL logic.

Please check and provide your inputs.

[Ankur Bawiskar]

@rahulrockkk 

what's the use-case to copy database view data to custom table?
why not expose that database view itself to your users via reports/dashboards if that's what your aim is?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[rahulrockkk]

Because we cannot write any ACL restriction on the Database View. We need to write some logic where the User related entity Risk and the related records only should be visible in the Database View records. 

[Ankur Bawiskar]

@rahulrockkk 

why would you allow any user to write database view record?

Database view simply joins 2 or more tables and shows the data

what's your actual business requirement?