column level permissions for Data Services

HOW TO: Create and configure column level permissions for Informatica Data Services 9.0.1 using command line options

Solution:

You can configure column level permissions for SQL Data Services only by using command line option in version 9.0.1. The command Infacmd sql SetColumnPermissions allows you to specify denied permission to any specific column within a virtual table.

<INFA_HOME>/isp/bin>infacmd sqlsetColumnPermissions

<-DomainName|-dn> domain_name

<-ServiceName|-sn> service_name

<-UserName|-un> user_name

<-Password|-pd> password

[<-SecurityDomain|-sdn> security_domain]

[<-ResilienceTimeout|-re> timeout_period_in_seconds]

<-SQLDataService|-sqlds> sql_data_service

<-Table|-t> schema.table

<-Column|-c> column

<<-GranteeUserName|-gun> grantee_user_name|<-GranteeGroupName|-ggn> grantee_group_name>

[<-GranteeSecurityDomain|-gsdn> grantee_security_domain]

[<-AllowedPermissions|-ap> list_of_allowed_permissions_separated_by_space]

[<-DeniedPermissions|-dp> list_of_denied_permissions_separated_by_space]

Example
infacmd sql SetColumnPermissions -dn empDomain -sn DISService -un Administrator -pd Adminpass –sqlds employee_APP.employees -t Employee -c Salary -gun Tom -dp SQL_Select

Applies To
Other Software: Informatica Developer