Permission on crontab & mysql


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Permission on crontab & mysql
# 1  
Old 05-23-2015
Permission on crontab & mysql

HI,

I am using centos 6 and finding difficultly in doing 2 below things.

1. i have a user praveen i want to allow him to create cron job of his own. so i have added his user id in cron.allow but still it is not allowing him to edit(even if i have created praveen from root user) or create his cron file name praveen. i have attached the screen shot for the same.

2. i have using mysql and have a database Learning. i want to give access to any user to connect to the same without using root login. how can this be done.

Thanks
PKS
Permission on crontab & mysql-crontabpng
# 2  
Old 05-23-2015
you cannot because I suppose the file called praveen belongs to root no? and is in Hmm I have no Centos, but usually would be found in /var/spool/cron/crontabs...
for praveen to edit that file he has only to do
Code:
crontab -e

Othewise he writes a crontab file in his home directory and loads it using
Code:
crontab mycronfile

# 3  
Old 05-24-2015
looking at your attachment, I wonder what is to be found in praveen's crontab file...
Do a
Code:
crontab -l

and show us its content and the perms on /var/spool/cron/crontabs directory and its content
Then I remember some OS are strict on applying the rules and so you have to include root also...
What are the perms on /etc/cron.allow?
For Q 2 you have to open another thread as it has nothing to do with this problematic...
# 4  
Old 05-24-2015
Possible the crontab/default editor is pointing to nowhere?
# 5  
Old 05-24-2015
Hi,

I was making a mistake just by giving * * * * * and no the script path which i have to run......not i have added it and it's fixed.

THANKS Everyone.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Crontab 2>&1 not emailing

I have a script that emails me when I run it manually, but the crontab I'm using must be 'silencing' the output? Here's what I have: */15 * * * * /usr/src/blah.sh > /dev/null 2>&1 I don't want it to email me every time it runs, just when I run the sendmail command inside the script if the... (13 Replies)
Discussion started by: unclecameron
13 Replies

2. Shell Programming and Scripting

set only some command & scripts permission to a particular user

hi, i am new in unix.......i am using bash and i want to create a user which has only some command and scripts permission.........is it possible? thanx (1 Reply)
Discussion started by: rakeshtomar82
1 Replies

3. Shell Programming and Scripting

PHP read large string & split in multidimensional arrays & assign fieldnames & write into MYSQL

Hi, I hope the title does not scare people to look into this thread but it describes roughly what I'm trying to do. I need a solution in PHP. I'm a programming beginner, so it might be that the approach to solve this, might be easier to solve with an other approach of someone else, so if you... (0 Replies)
Discussion started by: lowmaster
0 Replies

4. Web Development

[php] webpage with login & mysql-db

Hi all, What I was looking for before was a multi-user password manager, web-based! The offer of free or cheap tools of this kind is very pover. Or they are too complex (or too expensive) I'm not a web programmer but I now decided to set up a (php) website with login and based on this login... (1 Reply)
Discussion started by: thibautp
1 Replies

5. UNIX for Dummies Questions & Answers

What is the purpose of 2 >&1 in crontab?

while we editing the cron at the end of the cron what is the purpose of giving 2 >&1 (4 Replies)
Discussion started by: senmak
4 Replies

6. Fedora

Crontab & MAILTO

Hi there, I'm working with two servers, one with FEDORA 6 and the other one with FEDORA 7, and if I put these lines in crontab: MAILTO=MYADDRESS@mail.com */1 * * * * df -h everything works fine on FEDORA 7 , while it doesn't work on6?!?...and I find this message in the log file: MAIL... (2 Replies)
Discussion started by: Giordano Bruno
2 Replies

7. UNIX for Dummies Questions & Answers

group & user permission question

Folks; I'd like to create a group on my Linux box & add a few users to it. Is there a way to do so and restrict this group/users to have access to only one or directory trees? Let's say i need this group to only have a read write access to only these two directories /opt/Virtu & /fsn/comers ... (10 Replies)
Discussion started by: Katkota
10 Replies

8. UNIX for Dummies Questions & Answers

MySQL GRANT permission.

Hi, I'm one of a server administrators. I've the linux root account but I don't know the root password of MySQL (Server version: 5.0.32). I want to GRANT ALL PRIVILEGES to my MySQL account without changing the MySQL's root password. How can I do so? (0 Replies)
Discussion started by: mjdousti
0 Replies

9. UNIX for Dummies Questions & Answers

PHP & Apache & MySQL install how-to ?

how do i install php & mysql with apache on suse linux ??? apache was installed and configured when i installed linux. all its files are in different folders. e.g http files in usr/local/httpd/htdocs/ and its configs are in etc/httpd/ so how do i install php and get it to work with apache and... (4 Replies)
Discussion started by: perleo
4 Replies
Login or Register to Ask a Question