Tag Info

New answers tagged

0

Check the details in the Create an Extended Events Session Using Query Editor MSDN article. It's for SQL Server 2012, but it should be valid for 2008 too; the ALTER ANY EVENT SESSION permission should be granted.


7

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. EDIT: For clarity on the three options presented by explicitly mentioning the SQLAgentOperatorRole as an option and by adding some explanation on the third solution. (1) If the user is allowed to manage the execution of all jobs, ...


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



Top 50 recent answers are included