How to clear scheduled tasks from SD 4.5 database?
I've question.. I've in my admin interface many old informations about scheduled tasks.. I find out that I can clear (delete) this entries from my SD 4.5 database (Oracle). What permissions my SDDATA user must have to do that??
Now my user have permissions like: CREATE USER SDDATA IDENTIFIED BY VALUES DEFAULT TABLESPACE SDDATA_DATA TEMPORARY TABLESPACE SDDATA_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 5 System Privileges for SDDATA GRANT CREATE VIEW TO SDDATA; GRANT CREATE TABLE TO SDDATA; GRANT CREATE SESSION TO SDDATA; GRANT CREATE SYNONYM TO SDDATA; GRANT CREATE SEQUENCE TO SDDATA; -- 3 Tablespace Quotas for SDDATA ALTER USER SDDATA QUOTA UNLIMITED ON SDDATA_TEMP; ALTER USER SDDATA QUOTA UNLIMITED ON SDDATA_INDEX; ALTER USER SDDATA QUOTA UNLIMITED ON SDDATA_DATA;