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.
View the original post :
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)
Hi Peter,
We are using oracle 10g. I haven't tried this with any other database though.
Regards
-Sambit
View the original post :
http://www.jboss.org/index.html?module=bbop=viewtopicp=4242689#4242689
Reply to the post :
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4242689
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