Follow the principle of least privilege
The principle of least privilege states that users should be given the least amount of privilege to perform their jobs. Oracle recommends reviewing user privileges periodically to determine relevance to current job responsibilities.
Before executing data definition language (DDL) scripts, create a database user with the specified limited set of privileges. Do not provide users with DBA access.
Parent topic: General security principles