RLS manual (record level security)

Understanding basics of 1C:Enterprise platform. To start working with 1C:Enterprise platform visit Getting started page

#1
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Nov 25, 2011
Company: olllo

I cant find pure RLS related manual for 1C. Please help! where could I deeg ou tsuch crusual for me info

 
#2
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Hello!
Some docs are in progress, so please ask your questions and we will try to help you.

 
#3
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Nov 25, 2011
Company: olllo

ok, my question is: I want to restrict some roles in DB with RLS by key field - department. Please send me manual how I could fix it to olo_lo@mail.ru. AWAITING!

 
#4
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Nov 25, 2011
Company: olllo

still awaiting, please help, uppp

 
#5
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

One of possible solutions is:
1. create a Session Parameter of Department catalog reference type, for example UserDepartment
2. create a Role for users who will have restrictions
3. doubleclick it and navigate to documents (or whatever) which you need to restrict
4. in rights list mark and highlight Read right
5. over rights in Data Access Restrictions list add a new restriction
6. leave Margins column empty (value "Other Fields") this means that your restriction will be applied to all fields of your document
7. in Access Restrictions column click the select ("...") button
8. in Restrict Access click Query Builder button
9. on the Conditions tab navigate to and doubleclick the document's Department field and see on the right side a new condition appears
10. in the last column (after the equal sign in previous column) type the name of your session parameter
11. you will have something like that: WHERE Department = &UserDepartment

 
#6
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Nov 25, 2011
Company: olllo

I wonder, when you put in some relevant good doc's with pure examples for beginners

 
#7
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Please see charpter 5.5.4.8. Data Access Restriction of 1C:Enterprise 8.2 Developer Guide

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.