record delete restriction trigger

DELIMITER $$
CREATE TRIGGER trigger_name
BEFORE DELETE
ON table_name
FOR EACH ROW
BEGIN
    if SUBSTRING_INDEX(USER(),'@',1) NOT IN ('root') THEN
        CALL cannot_delete_error;
    END if;
END
$$

Comments

Post a Comment

Popular posts from this blog

Error while connecting RDP "an authentication error has occurred the token supplied to the function is invalid".

Image
an authentication error has occurred the token supplied to the function is invalid I have installed xrdp 0.9.8 at server side. Remote desktop connections are working fine when i am connect it from windows 8/10. but when i am trying to connect RDP from windows 7 it is showing error which is showing on left side. in xrdp 0.9.8 TLSv1.2 and TLSv1.3 is added by default. in older version of windows system TLSv1.3 was not supported. thats why it is not connecting with xrdp server. To resolve this issue from server side follow the steps below. 1. Login to xrdp server. 2. navigate to xrdp configuration file location, $cd /etc/xrdp $vim xrdp.ini replace ssl_protocols=TLSv1.2, TLSv1.3 with ssl_protocols=TLSv1, TLSv1.1 3. Restart xrdp service. $ service xrdp restart
Read more

Windows shared network printer issue in ubuntu 18.04

Windows shared network printing issue in ubuntu 18.04. - printers are installed in windows 8 machine and shared. - when try to find the network printer from ubuntu 18.04 using the ip of windows machine then it is showing an error  "no network printer found" - even, when we found the shared folders using smbclient command then it will showing an error smbclient -L 192.168.1.20 output: syslog option deprecated, Enter WORKGROUP\root's password:     Sharename       Type      Comment     ---------       ----      -------     ADMIN$          Disk      Remote Admin     Backup          Disk          bk              Disk          bkp             Disk          C$              Disk      Default share     Canon UFR II Color Class Driver Printer   Canon UFR II Color Class Driver     Canon-LBP2900-toc64 Printer   Canon LBP2900     Canon2900       Printer   \\MUIN-KHAN\Canon-LBP2900     D$              Disk      Default share     Data            Disk          HP-LaserJet-M
Read more

Rename printer from command line in ubuntu.

Rename printer name from backend without GUI. 1. rename the printer name into /etc/cups/printers.conf for E.g. OldName="Canon_LBP-2900_CAPT" NewName="Canon_LBP2900" Stop cups service first service cups stop  > /dev/null 2>&1 Replace the old name with new printer name sed -i 's/'$OldName'/'$NewName'/g' /etc/cups/printers.conf Restart cups service service cups restart  > /dev/null 2>&1 2. Also need to rename the ppd of the old printer which is located at /etc/cups/ppd rename the old printer ppd name  mv /etc/cups/ppd/"$OldName".ppd  /etc/cups/ppd/"$NewName".ppd Restart cups service service cups restart
Read more