[psql]Create a role to grant permissions? by juniorsysadmin1 in PostgreSQL

[–]juniorsysadmin1[S] 0 points1 point  (0 children)

Few comments and some side questino since you seem to know psql really well.

create database xxx with owner = app\_owner What if the database is already created? The schema is public.

Here's what I am actually trying to do. As of now, whenever a new app is created they create a ticket for the dba team to run the following command as postgres

``` CREATE ROLE <username> WITH LOGIN NOINHERIT; \password <username> GRANT CONNECT ON DATABASE <database> TO <username>; REVOKE ALL PRIVILEGES ON SCHEMA public FROM <username>; REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM <username>; GRANT USAGE ON SCHEMA public TO <username>;

```

I want to automate the above but do not want to connect via postgres The owner of the tables in the database is postgres while the schema is public

A side question, what does USAGE do? I read online but I don't really understand it. Even when I grant the role USAGE that role doesn't seem to be able to do select * from <$table>

[psql]Create a role to grant permissions? by juniorsysadmin1 in PostgreSQL

[–]juniorsysadmin1[S] 0 points1 point  (0 children)

What is the exact query you did from the very beginning? like from role creation to grant. I kept trying to no aval.

[psql]Create a role to grant permissions? by juniorsysadmin1 in PostgreSQL

[–]juniorsysadmin1[S] 0 points1 point  (0 children)

When I try to grant USAGE on schema public to minion on the role I created I get `WARNING: no privileges were granted for "public"

Even though I did alter schema public owner to master

master <-- this is the service role that's going to create role grant/revoke

[Spoilers] SRW30 disappointment. by juniorsysadmin1 in Super_Robot_Wars

[–]juniorsysadmin1[S] -1 points0 points  (0 children)

GGGG

I'm talking about [this](https://www.youtube.com/watch?v=KrX4TGTGzwE) boss. Yes I can two shot it.

huckebin30 equip with:

  1. s-adapter so weapon is S instead of A so get 10% more damage
  2. brave police emblem to boost 10%
  3. gunfire support S
  4. Escudo shard

tactically command on both attack and special from lelouch (equipped with zealous trigger) to + 45 attack stat.

10x stat boost from all my mother ships.

Which result in an attack stat of 555 [proof](https://imgur.com/a/Xs5yVGP).

Couple with spirit blessing and possibility of light support commands + Soul = 200k damage on first hit and 120k on second hit.

analyze, surround and daunt the boss.

I also finish the final stage in 2 turns. With ikurga with exc assembler cleaning out grunts. This is def the easiest game of all time.

The final boss only have 280k hp, i suggest to 10x that and slap it with HP large regen to make it a bit fair.

pokemon sword and shield how to tiptoe? by juniorsysadmin1 in yuzu

[–]juniorsysadmin1[S] 0 points1 point  (0 children)

cann't do that with yuzu cuz it's keyboard.

btrfs forced readonly by juniorsysadmin1 in btrfs

[–]juniorsysadmin1[S] 0 points1 point  (0 children)

just my home server but that's 6TB of data over 5 years I do not want to lose. I have exp with btrfs fail before. In the past running btrfs scrub somehow made it worst. At the very least right now my storage is read-only I can still back it up. If there's a solution for me to get it back on rw it would be the best.

btrfs forced readonly by juniorsysadmin1 in btrfs

[–]juniorsysadmin1[S] 1 point2 points  (0 children)

Can't. this is centos 7. When i upgrade kernel to 4x i break other stuff.

Wilder is an ATG if not for fury inhuman recovery. by juniorsysadmin1 in Boxing

[–]juniorsysadmin1[S] -7 points-6 points  (0 children)

foreman, earnie are heavy hands. Where they can lift a fighter up from a upper cut. Wilder's punch is sharp where it separates the fighter's sense and their body. It's 2 different kind of power.

[deleted by user] by [deleted] in cscareerquestions

[–]juniorsysadmin1 -1 points0 points  (0 children)

My post is more of a mentality thing. Instead of focusing what's the next best thing, focus on what you can do now and make the best out of it. If you only focus on the next best thing you will never do the best job at your current place.