New answers tagged users
2
votes
Unable to drop user due to assigned privileges?
This is the safe sequence of commands:
Repeat in every database of the same DB cluster, where the role may own anything or may have any privileges:
REASSIGN OWNED BY myuser TO rds_superuser; -- ...
- 170k
0
votes
Unable to drop user due to assigned privileges?
It seems you first need to drop default privileges you granted:
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema REVOKE SELECT ON TABLES FROM myuser;
You can get default privileges using the query from ...
- 8,965
1
vote
Accepted
MongoDB account -- is it an administrator's account?
Edit your configuration file (typically /etc/mongod.conf) to this
security:
authorization: disabled
As precaution in order to prevent unauthorized connections, you may also set
net:
port: 55555
...
- 2,883
0
votes
MongoDB account -- is it an administrator's account?
Yes it's administrator account... You just need to change to admin DB, where user information is. So, type "use admin" + enter. You can always check on what DB you are just type "db&...
- 5,673
1
vote
Unable to connect to Oracle user in pluggable database
from the output of listener-status above, I see that PDB1 is a known service for you listener.
means a connect: sqlplus uer/pwd@PDB1 'should' work.
You have configuered security, using a wallet. Are ...
1
vote
Accepted
Unable to connect to Oracle user in pluggable database
-- without specifying service_name, you will connect to the CDB (root con)
SQL>connect u/p<NOTHING_HERE>
-- the service_name 'PDB1' will be made available when pdb is created
SQL>!lsnrctl ...
- 637
Top 50 recent answers are included