This content has been marked as final. Show 5 replies
I'm trying to do the same as you and it's not working either!
Which version of the DB are you using ?
I actually want every user to be assigned to 1 a default group when they log in, but switch it to another group if they use a specific program, so I try to assign the default group by SERVICE_NAME.
What I found was that it doesn't work and leaves the user in the OTHER_GROUPS! So I'm going to try a logon trigger next and manually switch the user to the default group based on session, I'll try and post an update if I get anywhere.
Let me know if you have solved it with another method.
Ooops, just saw that your post was made 2008 !!!!!!!
933232 wrote:It seems you haven't asked any question yet over the Forum as your post count is 1
Try your question on stackoverflow.com. There are lot less useless advises in there.
At least all Oracle ACEs are responsible for having forum activity and we love share our knowledge
There're a lot of answered questions over the forum. So be polite!
Kamran Agayev A.