Forgot your password?
New user?
Grant Script
Document Actions
This script grants access to the user bie to a variety of OpenGroupware tables so that it can perform SELECT operations. If you BIE connects as a user other than bie then you'd need to change this.
GRANT SELECT ON address TO bie;
GRANT SELECT ON appointment_resource TO bie;
GRANT SELECT ON company TO bie;
GRANT SELECT ON company_assignment TO bie;
GRANT SELECT ON company_category TO bie;
GRANT SELECT ON company_info TO bie;
GRANT SELECT ON company_value TO bie;
GRANT SELECT ON enterprise TO bie;
GRANT SELECT ON job TO bie;
GRANT SELECT ON job_assignment TO bie;
GRANT SELECT ON job_history TO bie;
GRANT SELECT ON job_history_info TO bie;
GRANT SELECT ON job_resource_assignment TO bie;
GRANT SELECT ON person TO bie;
GRANT SELECT ON project TO bie;
GRANT SELECT ON project_company_assignment TO bie;
GRANT SELECT ON project_info TO bie;
GRANT SELECT ON session_log TO bie;
GRANT SELECT ON staff TO bie;
GRANT SELECT ON team TO bie;
GRANT SELECT ON telephone TO bie;
GRANT SELECT ON appointment_resource TO bie;
GRANT SELECT ON company TO bie;
GRANT SELECT ON company_assignment TO bie;
GRANT SELECT ON company_category TO bie;
GRANT SELECT ON company_info TO bie;
GRANT SELECT ON company_value TO bie;
GRANT SELECT ON enterprise TO bie;
GRANT SELECT ON job TO bie;
GRANT SELECT ON job_assignment TO bie;
GRANT SELECT ON job_history TO bie;
GRANT SELECT ON job_history_info TO bie;
GRANT SELECT ON job_resource_assignment TO bie;
GRANT SELECT ON person TO bie;
GRANT SELECT ON project TO bie;
GRANT SELECT ON project_company_assignment TO bie;
GRANT SELECT ON project_info TO bie;
GRANT SELECT ON session_log TO bie;
GRANT SELECT ON staff TO bie;
GRANT SELECT ON team TO bie;
GRANT SELECT ON telephone TO bie;
