MAXL - display user... need help

MAXL - display user... need help

Adam
Adam

May 10th, 2012, 5:01 pm #1

I'd like to get a list of users and their "application_access_type".

The DOC's show the "Output Columns" but can't seem to get it to work.... (http://docs.oracle.com/cd/E10530_01/doc ... spuser.htm)

Can anyone help?

Spool on to "C:\\App\\Security1.log";
Set timestamp on;
display user 'sample.sample' access_type;
spool off;
logout;
Quote
Share

Krishna
Krishna

May 10th, 2012, 5:46 pm #2

have to supply usedId to display user cmd.
'sample.sample' access_type;
looks like you are using appname.dbname and access_type is one of the output fields.

hope it helps
Krishna
Quote
Share

Joined: November 26th, 2001, 10:15 pm

May 10th, 2012, 5:49 pm #3

I'd like to get a list of users and their "application_access_type".

The DOC's show the "Output Columns" but can't seem to get it to work.... (http://docs.oracle.com/cd/E10530_01/doc ... spuser.htm)

Can anyone help?

Spool on to "C:\\App\\Security1.log";
Set timestamp on;
display user 'sample.sample' access_type;
spool off;
logout;
login hypadmin password on localhost ;

spool on to "c:\\tempdir\\users.log" ;

set column_width 100 ;

display user all ;

exit ;

If you want to get as much detailed information as possible, try throwing this in (way more info than application access type). NB -- I wrote this in 11.1.1.3 but I think 11.1.2.x is the same output even though what's stored in Essbase.sec is vastly different:
export security_file to data_file "c:\\temp\\essbasesec.txt" ;

Regards,

Cameron Lackpour

Quote
Like
Share

Anonymous
Anonymous

May 10th, 2012, 6:14 pm #4

have to supply usedId to display user cmd.
'sample.sample' access_type;
looks like you are using appname.dbname and access_type is one of the output fields.

hope it helps
Krishna
so that should be user and the output field is "access_type"?

Spool on to "C:\\App\\Security1.log";
Set timestamp on;
display user userid;
spool off;
logout;
Quote
Share

Anonymous
Anonymous

May 10th, 2012, 6:15 pm #5

login hypadmin password on localhost ;

spool on to "c:\\tempdir\\users.log" ;

set column_width 100 ;

display user all ;

exit ;

If you want to get as much detailed information as possible, try throwing this in (way more info than application access type). NB -- I wrote this in 11.1.1.3 but I think 11.1.2.x is the same output even though what's stored in Essbase.sec is vastly different:
export security_file to data_file "c:\\temp\\essbasesec.txt" ;

Regards,

Cameron Lackpour
Cameron, is that backwards compatible to 9.3?
Quote
Share

Joined: November 26th, 2001, 10:15 pm

May 10th, 2012, 6:30 pm #6

See the 9.3.1 docs:
http://docs.oracle.com/cd/E10530_01/doc ... spuser.htm

The only way to know is to try. That code works, although you'll likely want to change the directories.

Regards,

Cameron Lackpour
Quote
Like
Share

Joined: February 29th, 2012, 2:27 am

May 11th, 2012, 10:26 am #7

I'd like to get a list of users and their "application_access_type".

The DOC's show the "Output Columns" but can't seem to get it to work.... (http://docs.oracle.com/cd/E10530_01/doc ... spuser.htm)

Can anyone help?

Spool on to "C:\\App\\Security1.log";
Set timestamp on;
display user 'sample.sample' access_type;
spool off;
logout;
Thanks for the input.

Quote
Like
Share

Anonymous
Anonymous

May 14th, 2012, 1:09 pm #8

login hypadmin password on localhost ;

spool on to "c:\\tempdir\\users.log" ;

set column_width 100 ;

display user all ;

exit ;

If you want to get as much detailed information as possible, try throwing this in (way more info than application access type). NB -- I wrote this in 11.1.1.3 but I think 11.1.2.x is the same output even though what's stored in Essbase.sec is vastly different:
export security_file to data_file "c:\\temp\\essbasesec.txt" ;

Regards,

Cameron Lackpour
Just for the record Cameron, this does not work in 9.3.

Thanks,
Quote
Share


Confirmation of reply: