Oracle creates and gives permissions to users

--First step, backup data
--Step Two, delete the user

Cascade

--Step three, create the userCreateUserIstaudit identifiedBy""Default Tablespace Istaudit--Default table SpaceTemporaryTablespace Istaudit_temp ProfileDEFAULT;--Grant/revoke role Privileges granting permissionsGrant Aq_administrator_roleToIstaudit;Grant Aq_user_roleToIstaudit;Grant AuthenticateduserToIstaudit;Grant ConnectToIstaudit;Grant CtxappToIstaudit;Grant DBAToIstaudit;Grant Delete_catalog_roleToIstaudit;Grant EjbclientToIstaudit;Grant Execute_catalog_roleToIstaudit;Grant Exp_full_databaseToIstaudit;Grant Gather_system_statisticsToIstaudit;Grant Imp_full_databaseToIstaudit;--Grant/revoke System PrivilegesGrantCreateAnyProcedureTo IstauditWith adminOption;GrantCreateAny sequenceTo IstauditWith adminOption;GrantCreateAnyTableTo IstauditWith adminOption;Grant DebugAnyProcedureTo IstauditWith adminOption;Grant Debug Connect sessionTo IstauditWith adminOption;GrantDeleteAnyTableTo IstauditWith adminOption;GrantDropAnyTableToIstaudit;GrantExecuteAny classTo IstauditWith adminOption;GrantExecuteAny IndextypeTo IstauditWith adminOption;GrantExecuteAny libraryTo IstauditWith adminOption;GrantExecuteAnyProcedureTo IstauditWith adminOption;GrantExecuteAny programTo IstauditWith adminOption;Grant Global Query rewriteTo IstauditWith adminOption;GrantGrantAny object privilegeTo IstauditWith adminOption;GrantGrantAny privilegeTo IstauditWith adminOption;GrantInsertAnyTableTo IstauditWith adminOption;Grant Manage SchedulerTo IstauditWith adminOption;Grant MergeAnyViewTo IstauditWith adminOption;GrantSelectAny dictionaryTo IstauditWith adminOption;GrantSelectAny sequenceTo IstauditWith adminOption;GrantSelectAnyTableTo Istauditwith admin option;< Span style= "color: #0000ff;" >grant under view to Istaudit with admin option grant Unlimited tablespace to istaudit with admin option;update any table Span style= "color: #0000ff;" >to istaudit with admin option;      

> Disconnecting users

where username='taml';' sid,serial        

Oracle creates and gives permissions to users