Wednesday, December 21, 2011

Hyperion Queries

Hyperion Queries -


SELECT username, password FROM DBA_USERS;

SELECT name,password FROM SYS.USER$ WHERE password is not null;

desc CSS_USERS;


select NAME ,PASSWORD,DESCRIPTION, FIRSTNAME,LASTNAME from EPMSS.CSS_USERS;


select UPDATEDBY,CREATEDBY,ACCOUNTSTATUS,DESCRIPTION,LASTNAME,FIRSTNAME,PASSWORD,NAME from EPMSS.CSS_USERS;

1 comment: