-
1. Re: Jboss Portal DB Setup Issue
peterj Jul 9, 2009 11:32 AM (in response to sambit_dixit)What database? I use both MySQL and PostgreSQL and I create a user specifically for the Portal database and grant that user full access to that database. But that user does not have access to anything else.
-
2. Re: Jboss Portal DB Setup Issue
sambit_dixit Jul 9, 2009 2:19 PM (in response to sambit_dixit)Hi Peter,
We are using oracle 10g. I haven't tried this with any other database though.
Regards
-Sambit -
3. Re: Jboss Portal DB Setup Issue
sambit_dixit Jul 9, 2009 2:24 PM (in response to sambit_dixit)Hi Peter,
When you say full access, do you give DBA privileges for that user. In our case, we dont give DBA access to the user. Rather we give only ( select,insert,update,delete, references, alter, index) privileges on tables. For the sequences, we create synonyms and provide ( select,alter) privileges.
Regards
-Sambit -
4. Re: Jboss Portal DB Setup Issue
peterj Jul 9, 2009 3:08 PM (in response to sambit_dixit)I'll base my answers on a MySQL database. I give all privileges (there are quire a number of them) to the user on the created database. The user also has GRANT privileges, which enables that user to also grant the same privileges to others. I haven't tried creating a user without GRANT privilege, nor have I attempted to determine the minimum number of privileges required for the software to work.
By the way, Portal uses Hibernate for its data access, so any posts or blogs that deal with security issues with Hibernate on Oracle should apply to Portal.