New answers tagged privileges
no running....... code:- in mysql UPDATE mysql.proc p SET DEFINER = 'root@localhost' WHERE DEFINER='piccellecommerce@%' AND db='piccellnew';
The warning WARNING: no privileges were granted for "serial" indicates that the granting role doesn't have the necessary privilege to grant privileges on the object in question. Either execute the GRANT command as the role owning the sequence. Or do the same as superuser (default superuser is postgres). Or GRANT the necessary privilege to the role ...
SERIAL is an alias datatype for an INTEGER type column with a defult coming from a sequence. If you defined your table as having a SERIAL type column, then you need to get the actual name of the sequence from the table. Have a look at the output of \d your_table and retry your GRANT command with the proper sequence name. If you did name your sequence ...
How do I create /change a definer so that anyone can access my view like when it is on the web page and people do not need to log in to view the content? This problem did not arise until Mysql 5.5 I think. All my code was written using views in 5.15 and now I cannot get access to any of the view stuff on line
Are you sure public is a user and not a role? Privileges acquired via roles have no effect in PL/SQL context. You need to grant sufficient permissions for sys.dbms_alert to the user.
Top 50 recent answers are included