Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Database query (Roles)

Highlighted
Brian Alexander
Super Collector

Database query (Roles)

I want to query the SD database to get a list of all fields that a Role has 'write' access to on a given form (Change, SC, etc). I can get all the ones with 'view' and 'hide' access with the query below.. Any idea how to get the ones with 'write' access?

SELECT DISTINCT rol_description, ent_name, lal_text, ata_modify
FROM rep_roles, ifc_attributes, ifc_entities, rep_attribute_access,
rep_entity_access, rep_labels_locale
WHERE ena_rol_oid = rol_oid
AND ata_ena_oid = ena_oid
AND ena_ent_oid = ent_oid
AND ata_atr_oid = atr_oid
AND atr_lbl_oid = lal_lbl_oid
ORDER BY rol_description, ent_name, lal_text
2 REPLIES
Jasper Verweij
Honored Contributor

Re: Database query (Roles)

Brian,

Write access is effective when there is no reference between attribute and rep_attribute_Access!

Jasper
Brian Alexander
Super Collector

Re: Database query (Roles)

Yes I knew that already, but isn't there somewhere in the database where I could find a list of ALL fields for a given record type?
//Add this to "OnDomLoad" event