Tag Info

New answers tagged

6

It is possible to set up a method to grant rights to run a job that a user does not have enough authority to run on its own. Erland Sommarskog has written a lot on how to grant permissions through stored procedures using counter-signatures. He has a solution at: http://www.sommarskog.se/grantperm.html#countersignatures The key point is: "To be able to ...


0

You can create a stored procedure with execute as owner to only one table or a store procedure to any table. In the next code is SP to truncate any table without assing permission of db_owner or other: USE [database name] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Yimy Orley ...


1

You can have stored procedures execute as the definer instead of the invoker: CREATE DEFINER = 'admin'@'localhost' PROCEDURE p1() SQL SECURITY DEFINER BEGIN UPDATE t1 SET counter = counter + 1; END; See: Access Control for Stored Programs and Views


0

You most probably need: GRANT USAGE ON SEQUENCE my_table_id_seq TO writer; Per documentation: USAGE ... For sequences, this privilege allows the use of the currval and nextval functions. nextval() is the reason you need the USAGE privilege on the sequence for a table with serial column. Details in this related answer on SO. Since a sequence ...


1

Roles and groups are not supported by MySQL Server. Groups are sets of users. The concept of roles is a group of permissions that can be assigned to a group or a user. Workbench emulates roles by handling them at client side: Adding a role on workbench. You can access this tab on the Users and privileges tab. I want the user to simply create tables, ...


1

Solution founded: To repair this issue I must execute this comand: chcon -t httpd_user_rw_content_t pgpool.conf and chcon -t httpd_user_rw_content_t pcp.conf then pgpooladmin will show that those files are writable and will allow to click "Next" to install pgpoolAdmin. Yay Cheers :D


1

To troubleshoot, I would start by looking at the output of SELECT current_user; and SHOW search_path;. Also, the output of \dp termin in psql. My suspicion here is that you are stumbling over mixed case identifiers. The error message mentions a table Map Notice the capital letter M. Are you sure there is no mix-up with another table named map (lower ...



Top 50 recent answers are included