-Y, --permissions

Gives permissions to users/groups to see the new table/query when creating or modifying an object.

Syntax

-Y [ID1],[ID2],...,[IDn]
--permissions=[ID1],[ID2],...,[IDn]

Description

You can give users/groups permissions by adding them to the permissions list. Alternatively, you can pass '.' to indicate that this table should inherit its permissions from the folder in which it resides, and '!' to make the table private.

By default, tables are private. If the user uploads a table from a SAM pool, the default permissions is inherit.

Note: For backwards compatibility, '*' can indicate inherited permissions and 'Y' can indicate a private table.