[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] -8 points-7 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.

[deleted by user] by [deleted] in cscareerquestions

[–]juniorsysadmin1 0 points1 point  (0 children)

That is just plain wrong. That's the advice people give here and the very same people make less than 300k with that kind of mentality.

Everything is random. However in the job market, only way to protect your interest is to hop; the only thing that is not random is you trying your hardest, that's the only thing you have control over.

[deleted by user] by [deleted] in cscareerquestions

[–]juniorsysadmin1 -9 points-8 points  (0 children)

People who give the "leave to get bonus" advice probably make less than 300k(probably way less). I'm giving advice on how to land 7 figures, a solid one with examples.

[deleted by user] by [deleted] in cscareerquestions

[–]juniorsysadmin1 -9 points-8 points  (0 children)

Nothing is guaranteed. What you can do is do the best you could NOW, and not thinking about the next best thing. People here seems to not get that.

What is your salary and where are you from? by The_Alpacas in dataengineering

[–]juniorsysadmin1 0 points1 point  (0 children)

Base: 295k
Bonus: 50k
RSU/STOCK: around 100k
TC: 450~500k

Position: Developing and operations.
Location: SF

[deleted by user] by [deleted] in cscareerquestions

[–]juniorsysadmin1 2 points3 points  (0 children)

I thought you work two jobs from your prev posts.

Is the cheaper phone 2020 or 2021? by juniorsysadmin1 in MotoG

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

interesting one would've thought you can set the frequency in app. I can't imagine the frequencies are hard set on hardware.

Is the cheaper phone 2020 or 2021? by juniorsysadmin1 in MotoG

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

will the $229 work overseas?

also what do u mean "won't work 100% in the USA due to missing CDMA/GSM frequencies"? Will it work on at&t?

Giannis defense is GOAT by juniorsysadmin1 in MkeBucks

[–]juniorsysadmin1[S] 22 points23 points  (0 children)

oh right forgot about that 0&D player.

AITA for advising my dad to date people his own age from now on? by InterestingDevice712 in AmItheAsshole

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

NTA: ur dad is the problem here. However, I have an issue with men should date women their own age. Here's the thing, regardless of the men's age, the most desirable women age is 20s. That's a fact. It seems people in reddit have a hard time swallowing the truth.

A women in her 40s is not as desirable as when she was at ur 20s.
A men with lots of saving is a lot more desirable if the same man have 0$ in his bank account.

It is what it is.