Normal Topic Security - best way to block user deletion? (Read 500 times)
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Security - best way to block user deletion?
Apr 11th, 2007 at 6:11pm
Print Post Print Post  
I've come to the point where I'm applying Security to one of my databases.  I'm reading the book and I see that users in the Data Entry group cannot Mass Delete, but can still delete individual records.  I need to block that ability (no one but myself, in the Admin group, should be able to delete records).  Can someone with experience with this point me in the direction of the quickest, easiest way to deal with this issue?  Thanks.
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Security - best way to block user deletion?
Reply #1 - Apr 11th, 2007 at 6:30pm
Print Post Print Post  
NotifyForm(4) prevents delete.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Security - best way to block user deletion?
Reply #2 - Apr 11th, 2007 at 7:21pm
Print Post Print Post  
Cool, thanks Ray.  OK, so I'm imagining an On-Form Entry test such as
Code
Select All
IF NOT @GROUP = "Admin"
THEN NOTIFYFORM(4) 


Can it be that clean or do I need to get fancier?
  

**
Captain Infinity
Back to top
IP Logged