• Home
  • The Museum System
  • Business Intelligence
  • About Chad

Chad Petrovay

Tips and tricks for cultural heritage data management

Month: May 2017

SQL Scripting, The Museum System

Quick, Hide the Money!

Chad Petrovay 23 May , 2017

When preparing for training sessions, it is a good idea to elevate your users’ permissions so that they can fully participate in training. However, this can expose users to highly sensitive information – such as valuations – that they would not otherwise have access to. This makes it necessary to hide the money.

Tweet
Share
Share
Pin
Continue Reading
Database Administration, The Museum System

Auditing User Security Profiles

Chad Petrovay 19 May , 2017

Once you have conceptualized and named your security groups and created them in the Database Configuration tool, it’s time to apply them to your userbase, and apply them consistently. Here is a Crystal Report that you can use to see users organized by security group and department. It’s a useful tool for being able to …

Tweet
Share
Share
Pin
Continue Reading
The Museum System

Naming Convention for Security Groups

Chad Petrovay 16 May , 2017 1

Setting up appropriate security groups for your TMS instance is an important, and often overlooked, function of the system administrator. I have heard of many institutions that operate TMS using only the default groups, meaning that every user has system administrator privileges. Setting up security groups is more tedium than anything else; but requires two …

Tweet
Share
Share
Pin
Continue Reading

Tags

advanced query Alternate Numbers backup solution batch assign bibliography Collective Imagination Constituents contact details Crystal Reports data profiling data quality data scrubbing data security data standards dbconfig digital images end-user support Events freebie Function key intangible objects library system list view Location Authority Locations Authority Media Objects Packages permissions Photosynth preaccession productivity querying Reluctant DBA remote access security group slide deck Social media SQL View statistics status flags text entries training virtual objects webinar

Categories

  • Business Intelligence (6)
  • Data Governance (4)
  • Database Administration (5)
  • Miscellanea (2)
  • SQL Scripting (17)
  • The Museum System (25)
  • xperience Gallery (2)
Chad Petrovay All rights reserved.
Powered by WordPress Theme by alfisahr