17 Mayıs 2010

Viewing Information About Database Users and Profiles

The following data dictionary views contain information about database users and profiles:
ViewDescription
DBA_USERS
ALL_USERS
USER_USERS
DBA view describes all users of the database. ALL view lists users visible to the current user, but does not describe them. USER view describes only the current user.
DBA_TS_QUOTAS
USER_TS_QUOTAS
Describes tablespace quotas for users.
USER_PASSWORD_LIMITS
Describes the password profile parameters that are assigned to the user.
USER_RESOURCE_LIMITS
Displays the resource limits for the current user.
DBA_PROFILES
Displays all profiles and their limits.
RESOURCE_COST
Lists the cost for each resource.
V$SESSION
Lists session information for each current session. Includes user name.
V$SESSTAT
Lists user session statistics.
V$STATNAME
Displays decoded statistic names for the statistics shown in the V$SESSTAT view.
PROXY_USERS
Describes users who can assume the identity of other users.

14 Mayıs 2010

SLCIAF: Searching files that includes a given text

today on _simple linux commands i always forget_ series :


Searching files that includes a given text. 


find . -exec grep -l “string to find” {} \;