Stack Overflow
Stack Overflow

Questions tagged [createuser]

144 questions
70
votes
4 answers

set blank password for PostgreSQL user

I use postgresql command 'createuser myusername'. It prompts me for password always. If I leave password blank it gives an error that no password is specified. I simply want to create a user with blank/no password and I'm not able to do it with…
othman
  • 4,428
  • 6
  • 34
  • 45
22
votes
3 answers

ORA-00988: missing or invalid password(s)

I'm trying to change an oracle password: alter user FOO identified by 'BAR'; and I'm getting the following back: Error starting at line 120 in command: alter user FOO identified by 'BAR' Error report: SQL Error: ORA-00988: missing or invalid…
inanutshellus
  • 9,683
  • 9
  • 53
  • 71
18
votes
3 answers

Using ASP .NET Membership and Profile with MVC, how can I create a user and set it to HttpContext.Current.User?

I implemented a custom Profile object in code as described by Joel here: How to assign Profile values? I can't get it to work when I'm creating a new user, however. When I do this: Membership.CreateUser(userName,…
Jeremy Gruenwald
  • 1,947
  • 1
  • 19
  • 18
14
votes
5 answers

How to fix ERROR 1726 (HY000): Storage engine 'MyISAM' does not support system tables. in Mysql 8.0 after CREATE USER

I have an installation of Debian Stretch and a new installation of Mysql 8.0 (no changes in configuration yet). When I try to create a new user with: mysql> CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'xyz'; I got the following: ERROR 1726…
user3717337
  • 205
  • 1
  • 3
  • 9
13
votes
4 answers

Creating an Oracle User if it doesn't already exist

I am trying to create a script that will create users if they do not already exist. CREATE USER "Kyle" PROFILE "DEFAULT" IDENTIFIED BY "password" ACCOUNT UNLOCK WHERE NOT IN //Also tried 'WHERE NOT EXISTS' ( SELECT username FROM all_users WHERE…
Kyle Williamson
  • 2,251
  • 6
  • 43
  • 75
11
votes
2 answers

MongoDB - Not Authorized to Execute Command

I have successfully enabled authorization on MongoDB and I have created an account on the admin database and then I created an account for my database called test. The following connection string to connect to my test database works successfully:…
Help
  • 161
  • 1
  • 2
  • 14
9
votes
5 answers

How do I solve this problem to use psql? | psql: error: FATAL: role "postgres" does not exist

I'm having trouble using PostgreSQL. I have recently installed this version (13+223.pgdg20.04+1) of postgresql package in ubuntu 20.04. I'm trying to run psql command, but I get the following error: psql: error: FATAL: role "my_username" does not…
DonLarry
  • 702
  • 2
  • 11
  • 22
9
votes
2 answers

Django Unknown field(s) (username) specified for PoUser

I got this error because I create a custom usermodel, and When I got all setup, which I look into the django/contrib/auth/models.py, I set the email as USERNAME_FIELD, and REQUIRED_FIELD is some field that is not defined in AbstractBaseUser and…
moojun
  • 105
  • 1
  • 1
  • 5
7
votes
4 answers

Restrict user privileges to one particular database only

PostgreSQL Version 9.1, i am logging into database with default user: "postgres" and my database contains default role "public" list of database i have, 1.database1 2.database2 3.database3 now, i need to create a user "newuser" which will have only…
MAHI
  • 9,263
  • 11
  • 36
  • 47
6
votes
2 answers

ORA-65096: invalid common user or role name

Hi I've tried to create a new user in Oracle 18c XE, but I get ORA-65096: invalid common user or role name error when writing create user student identified by "student"; I've tried to change the container to PDB by SQL> alter session set…
Cristina Moroti
  • 77
  • 1
  • 1
  • 8
6
votes
0 answers

auth0 Custom Database Action Script - How to access user_id?

I'm using auth0, I'm making a script on create under Action Scripts to save user to my mongoDB database. I only need to save the email and user_id, but I can't find the user_id? Code is below, but the user only returns:…
Kevin Danikowski
  • 4,620
  • 6
  • 41
  • 75
5
votes
3 answers

Postgres createuser command not found after installing with homebrew on my Mac

lawn-128-61-59-74:~ postgres$ createuser -R -P -S -D fhir After running "brew install postgresql" and running postgres, when running the above command I am getting the following error: "-bash: createuser: command not found"
luii
  • 319
  • 3
  • 5
  • 16
4
votes
2 answers

Should I create a database for every user in PostgreSQL?

My question is: when I create a PostgreSQL user different from the default postgres user, should I also create a new database for that user to connect to? What's the point of a setup like that?
erod
  • 181
  • 1
  • 17
4
votes
1 answer

CREATE USER in MS Access 2010

I have been searching for several hours regarding how to create a user using SQL for a database I am building in Access. I found several sources on Microsoft's website that say I can use the CREATE USER command to do this. However, whenever I…
Anakela
  • 65
  • 7
3
votes
3 answers

Error: couldn't add user: No role named root@test

I am trying to create user for my mongo database. Using MongoDB Query: db.createUser({user: 'administrator', pwd: '1234567890', roles: ['root']}) 2019-01-29T11:31:32.521+0530 E QUERY [js] Error: couldn't add user: No role named root@test…
Vijay Prajapati
  • 208
  • 1
  • 5
  • 19
1
2 3
…
9 10