Get-OraclePrivileges

NAME Get-OraclePrivileges



SYNOPSIS

Returns the Privileges in an Oracle DB





SYNTAX

Get-OraclePrivileges [-TargetDB] <String[]> [[-SQLFilter] <String>] [[-DBUser] <String>] [-PasswordPrompt]

[[-Parallelism] <Int32>] [<CommonParameters>]





DESCRIPTION

This function returns the Privileges for users and roles in an Oracle DB





PARAMETERS

-TargetDB <String[]>

It can check several databases at once



Required? true

Position? 1

Default value

Accept pipeline input? true (ByValue)

Accept wildcard characters? false



-SQLFilter <String>

SQL filter to add in the WHERE section of the query



Required? false

Position? 2

Default value

Accept pipeline input? false

Accept wildcard characters? false



-DBUser <String>

Username if required



Required? false

Position? 3

Default value

Accept pipeline input? false

Accept wildcard characters? false



-PasswordPrompt [<SwitchParameter>]

Flag to ask for a password



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-Parallelism <Int32>

Parallelism Degree



Required? false

Position? 4

Default value 1

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Get-OraclePrivileges -TargetDB myorcl -SQLFilter "grantee ='DB_USER_OR_ROLE'"















RELATED LINKS





CommonParameters : True

WorkflowCommonParameters : False

details : @{name=Use-OracleDB; noun=; verb=}

Syntax : @{syntaxItem=System.Object[]}

parameters : @{parameter=System.Object[]}

inputTypes : @{inputType=}

returnValues : @{returnValue=}

aliases : ora-query



remarks : Get-Help cannot find the Help files for this cmdlet on this computer. It is displaying only

partial help.

-- To download and install Help files for the module that includes this cmdlet, use

Update-Help.

alertSet :

description :

examples :

Synopsis :

Use-OracleDB [-TargetDB] <string[]> [-SQLQuery] <string> [-DBUser <string>]

[-PasswordPrompt] [-SecurePass <securestring>] [-DumpFile <string>] [-Parallelism <int>]

[-JobPrefix <string>] [-Scratch] [-Timeout <int>] [-HTML] [-PlainText] [-Silent]

[-ErrorLog] [-ErrorLogFile <string>] [-WhatIf] [-Confirm] [<CommonParameters>]



Use-OracleDB [-TargetDB] <string[]> [-SQLScript] <string> [-DBUser <string>]

[-PasswordPrompt] [-SecurePass <securestring>] [-DumpFile <string>] [-Parallelism <int>]

[-JobPrefix <string>] [-Scratch] [-Timeout <int>] [-HTML] [-PlainText] [-Silent]

[-ErrorLog] [-ErrorLogFile <string>] [-WhatIf] [-Confirm] [<CommonParameters>]



ModuleName : JS.OracleDatabase

nonTerminatingErrors :

xmlns:command : http://schemas.microsoft.com/maml/dev/command/2004/10

xmlns:dev : http://schemas.microsoft.com/maml/dev/2004/10

xmlns:maml : http://schemas.microsoft.com/maml/2004/10

Name : Use-OracleDB

Category : Function

Component :

Role :

Functionality :