Data level security

Question:
My environment is Win95, PB6.5, and Sybase SQL Server 11.0x. The table consists of entity, center, account, name, dollars, and hours. I need to be able to restrict access to data based on values contained in entity and center. The application is developed and works correctly without the restrictions. The application will be used by multiple users with varying degrees of access. I thought about using views, but the datawindow is always username.view_name and I haven’t been able to set up username as a usable variable for passing to the datawindow. Where should I continue my search?

Answer:
Your best bet will be to lay synonyms on the user accounts that point to either the tables or views. That way you get the most flexibility today and into the future. You will have to write a procedure that sets up your users and creates the synonyms. You could opt for public synonyms, but I’ve found the best way to go is with synonyms on each account.

Then in PB just call the synonyms from your datawindows and SQL. The sysnonyms point back to the real table or view in the master domain account.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may

man on floor with data

DevX Quick Guide to Data Ingestion

One of the biggest trends of the 21st century is the massive surge in internet usage. With major innovations such as smart technology, social media, and online shopping sites, the internet has become an essential part of everyday life for a large portion of the population. Due to this internet

payment via phone

7 Ways Technology Has Changed Traditional Payments

In today’s digital world, technology has changed how we make payments. From contactless cards to mobile wallets, it’s now easier to pay for goods and services without carrying cash or using a checkbook. This article will look at seven of the most significant ways technology has transformed traditional payment methods.