Would it be possible to get the Resource Type column in the Profiles Info tab? This would clearly distinguish those that are only enforced when RESOURCE_LIMIT='TRUE' from those that are always enforced. These are the RESOURCE_TYPEs 'KERNEL' and 'PASSWORD' in DBA_PROFILES. The list appears to already be sorted on that column although not exactly in PROFILE$.RESOURCE# order.
Feel free to tell me no. It would be helpful but might confuse some because of the misleading term 'KERNEL'.
Cheers,
Russ
Yeah I think it should be there. It's relevant. And if 'KERNEL' is confusing, that's on Oracle, not us. I like to use whatever terminology they use. I don't think I'm doing anyone any favors by trying to reword it.
BTW, The list in your screen shot is sorted in a way that made sense to me when I coded it. Profile Name, non-password stuff, password stuff. "Inactive Account Time" seems like it's in the wrong position though. You can always click a column header to alphabetize if you want.
Actually, I want to be able to sort them by Resource Type.
I see that RESOURCE_TYPE pertains to each property of the profile, not the profile as a whole. Forget I said anything about the LHS (I'm editing those comments out now). Resource type should be an additional column in the grid in your screen shot.
What makes it relvant, I think, is the connection with RESOURCE_LIMIT.
I was poking around with the query in DBA_PROFILES evaluating all of its 'decodes' when I realized that the Toad RHS for an individual profile does not include Resource Type. It just seemed relevant to me.
Yes. I wasn't sure what you were getting at about the LHS thing and was going to ask until your new post.
Cheers,
Russ
Didn't Toad separate the Resource Types into separate pages years ago? I seem to remember something like that.
I think it is best as just a column in the grid.
Cheers,
Russ
I don't know offhand when they added it, but I was about to say earlier that it probably didn't exist when I reworked the Schema Browser code (which was a long time ago), otherwise it would be in there.
I just looked it up. They added it in Oracle 8.0. 
LOLs I was talking about Toad once having the two Resource Types on separate pages in Schema Browser profile details. I seem to remember something like that, but maybe I'm confusing it with something else.
Cheers,
Russ
The Create/Alter profile window has password params on a separate tab from non-password params.
Ah, that's where I remember it. I generally don't use Schema Browser to create things, so I don't often go into those.
I notice that in Create Profile, the KERNEL resources are called Resource Parameters and PASSWORD resources are called Password Parameters. In this case, at least, y'all didn't adopt Oracle terminology. I don't have a problem with that in general, but the term "Parameters" there could conflate them in people's minds with database parameters. I have been writing some documentation for my peeps in which I have been careful not to call them parameters. They are Resources with Limits. But since I am a nuts-and-bolts DBA--don't use OEM, DBCA, and such like--I am strict about terminology. Y'all do what you want.
Cheers,
Russ
Thanks for pointing that out. You are correct.
