I dont know how well my newsreader will post this code so I apologize
for the formatting.
If you dont give the user SAM admin privileges or default on all the
roles a user will not be able to login.

This shows you can set a role in a package.
My issue was that when I import SAM I drop and cascade first.
Then issue a create user sam statement then use import. That limits all
the creation errors and ensures the old schema is gone.

Well after doing this and recreating the users that were captured
during the export the users could not login.
It was because sam did not have admin privs.
Received on Wed Feb 23 2005 - 13:59:31 CST