0 - 3 of 3 tags for profiles

A profile may be associated with multiple account strings.
What is the query to know the various account strings associated with a particular profile?
Thanks in Advance!!

We are having ~1000 Business Users, who are accessing the Teradata Production system.

The business users are assigned to a common profile.We want to set a spool space limit for the business users at profile level.

How can we get the value of spool space that will enable the buiness user's queries to run smoothly.

What do you guys recommend, are the best practices on creating Roles and Profiles?
Right now I have 9 different roles according to user's resposibilities, rights and environment, and clearly most of them must have different priority.  So I created 9 profiles, one for each role.