Parameters Flashcards
What are the different types of parameters
Account, Session, object
Where can account params be set
Account level only
Who can set account level params
Users with the appropriate admin role
What command sets account level params
Alter Account
Most params are what
Session params
How does an account admin set session permissions at the account level
Alter Account SET ….
What does it mean to set session permissions at the account level
set default for individual users and their sessions
What level overrides session permissions at the account level
User
What command sets session permissions at the user level
Alter User – done by admin with appropriate permissions, typically SECURITYADMIN
What does it mean to set session permissions at the user level
sets default for any session started by the user
Can users override their session permissions set at the user level
yes, by using Alter User
What level overrides permissions at the user level
Session
What command is used to set session permissions at the session level
Alter Session
What does it mean to set session permission at the session level
sets session params with the user’s session
What command sets object permissions on the account level
Alter Account
What does it mean to set object permissions at the account level
Default to individual users and their sessions
What level overrides the object permissions at the account level
User
What are the objects at the object level
Warehouse, database, schema, Table/pipe, etc
What is the hierarchy of objects at the object level
Table/pipe > Schema > Database
What are the commands to override params for an individual object
Create “object-name”
Alter “object-name”
What does the SHOW PARAMETERS command do
displays a list of parameters, along with the current and default values
What type of parameters are shown by SHOW PARAMETERS by default
Session only
What is the command to show parameters for a specific object
show parameters in database “database-name”
show parameters in warehouse “warehouse-name”
What command shows all parameters including account and object parameters
show parameters in account
How do you filter parameters by name
show parameters like ‘%time%’
show parameters like ‘%time%’ in account
