var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sql permissions question
I need someone to be able to create procedures and create jobs on our sql servers. What is the lowest level of access I should give them? I don't want to give sa access....
The following sql code showing grant 'select','insert','update','delete' to user 'usr' to table 'codeq':
REVOKE ALL PRIVILEGES ON `codeq` . * FROM "usr"@ "localhost";
REVOKE GRANT OPTION ON `codeq` . * FROM "usr"@ "localhost";
GRANT SELECT ,
DELETE ON `codeq` . * TO "usr"@ "localhost";
Well I don't want to grant permissions on a particular object. I want the user to be able to :
1) create stored procedures
2) create jobs .
You have only to grant permission for creating stored procedures:
grant CREATE PROCEDURE to youruser
sp_add_job, etc. - execute permissions default to the public role (you do not need to grant any permissions).
Of course it needs to give to youruser some permissions on db objects.
grant permission to users for objercts that are accessed by the job? I don't think so. the job is executed in the security context of sqlagent account, not user account.