Minimum privileges to run a Xcloner from a cronjob | General Questions and Support | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Avatar
Lost password?
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
The forums are currently locked and only available for read only access
sp_TopicIcon
Minimum privileges to run a Xcloner from a cronjob
January 11, 2014
2:45 pm
Avatar
lesm
Member
Members
Forum Posts: 12
Member Since:
November 17, 2012
sp_UserOfflineSmall Offline
Hi Ovidiu,
My cronjob doesn't allow passwords using symbols, so I must create a less secure user/password to access the DB from a cronjob.
Please let me know what are the minimum MySql privileges required to run Xcloner with a cronjob.
 
ALTER
CREATE
CREATE ROUTINE
CREATE TEMPORARY TABLES
CREATE VIEW
DELETE
DROP
EXECUTE
INDEX
INSERT
LOCK TABLES
REFERENCES
SELECT
SHOW VIEW
TRIGGER
UPDATE
Tnak you
January 12, 2014
4:25 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

The permissions should be the ones related to reading, so:

 

INDEX

CREATE VIEW

REFERENCES

SELECT

SHOW VIEW

 

Ovidiu

January 13, 2014
3:07 pm
Avatar
lesm
Member
Members
Forum Posts: 12
Member Since:
November 17, 2012
sp_UserOfflineSmall Offline

Thanks a lot Ovidiu.

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
Andy: 21
D: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10030
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Omar Vera
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0