Channels
pacc-may-31-2023
prefect-ai
pacc-clearcover-june-12-2023
marvin-in-the-wild
data-ecosystem
geo-israel
pacc-june-14-2023
geo-japan
prefect-cloud
ppcc-may-16-2023
prefect-azure
prefect-docker
prefect-recipes
gratitude
geo-nyc
geo-bay-area
geo-boston
geo-london
geo-dc
geo-chicago
geo-berlin
geo-texas
geo-seattle
geo-colorado
prefect-community
data-tricks-and-tips
prefect-aws
prefect-gcp
introductions
find-a-prefect-job
prefect-dbt
random
events
ask-marvin
show-us-what-you-got
prefect-getting-started
prefect-integrations
prefect-contributors
best-practices-coordination-plane
announcements
prefect-server
prefect-ui
prefect-kubernetes
Title
g
Giacomo Chiarella
05/08/2023, 11:09 AMHi everyone! Is it possible to prevent any delete through web ui and let it enabled from cli?
d
Deceivious
05/08/2023, 12:04 PMcloud or self hosted?
g
Giacomo Chiarella
05/08/2023, 12:11 PMself-hosted
d
Deceivious
05/08/2023, 12:11 PMMaybe you could try create a new user with no delete permissions on the main tables and use that database user while connecting
For the API and UI , use user with no delete permission.
For CLI use another user with all permission
g
Giacomo Chiarella
05/08/2023, 12:14 PMmmm you suggest to set environments variables when executing cli commands
PREFECT_API_DATABASE_PASSWORD: ********
PREFECT_API_DATABASE_CONNECTION_URLseems a bit of a workaround
d
Deceivious
05/08/2023, 12:14 PMor create profiles
g
Giacomo Chiarella
05/08/2023, 12:14 PMhow do you create profiles?
d
Deceivious
05/08/2023, 12:15 PMtry `pefect --help``
prefect*
g
Giacomo Chiarella
05/08/2023, 12:17 PMseems interesting feature, thanks!
d
Deceivious
05/08/2023, 12:18 PMif its just local server, id just create a .sh file
with 2 configs and use that sh file to spin up the server
g
Giacomo Chiarella
05/08/2023, 12:18 PMyou mean using env vars right?
d
Deceivious
05/08/2023, 12:18 PMyes
g
Giacomo Chiarella
05/08/2023, 12:26 PMif prefect profile command is used, this creates profiles in the database, right?
d
Deceivious
05/08/2023, 12:26 PMno
g
Giacomo Chiarella
05/08/2023, 12:26 PMconfig files? like yml?
d
Deceivious
05/08/2023, 12:26 PMit creates the profiles in ~/.prefect
g
Giacomo Chiarella
05/08/2023, 12:26 PMok, good
d
Deceivious
05/08/2023, 12:27 PMdont believe me blindly though. 😄
👍 1
g
Giacomo Chiarella
05/08/2023, 12:27 PMone last question, do you know what are the priorities? env vars if a profile is not specified?
d
Deceivious
05/08/2023, 12:28 PMunsure
g
Giacomo Chiarella
05/08/2023, 12:28 PMok ok, I will investigate, thanks!
by the way, you were right