You can revoke the super user privileges previously granted to a database user by running the below sql command where username is the name of the user.
alter user username nocreateuser; commit;
You can revoke the super user privileges previously granted to a database user by running the below sql command where username is the name of the user.
alter user username nocreateuser; commit;