Ошибка нет прав на создание базы данных

The root user is an account on the system independent from Postgres. There is only one root user.

A superuser is an account in Postgres with access to everything. There may be many superusers.

System accounts and Postgres accounts are different things, although unless you specify a Postgres username when you connect to the database (through utilities like psql, createdb, dropdb, or otherwise), it will use the current system user’s name in hopes that there is a corresponding Postgres account with the same name. The root user does not, by default, have a corresponding account in Postgres.

When you install Postgres on *nix, it creates both a superuser named postgres and a system user named postgres.

Therefore, when you need to do something with Postgres as the built-in superuser, you have two options:

1. You may sudo su - postgres to become the postgres system user and execute your command (createdb, psql, etc). Because the system user has the same name as the database superuser, your command will connect as the appropriate account.
2. You may specify the username to execute as with the -U switch, eg psql -U postgres ....

Depending on your Postgres server’s authentication settings, you may be required to enter a password with either or both connection methods.

The root user is an account on the system independent from Postgres. There is only one root user.

A superuser is an account in Postgres with access to everything. There may be many superusers.

System accounts and Postgres accounts are different things, although unless you specify a Postgres username when you connect to the database (through utilities like psql, createdb, dropdb, or otherwise), it will use the current system user’s name in hopes that there is a corresponding Postgres account with the same name. The root user does not, by default, have a corresponding account in Postgres.

When you install Postgres on *nix, it creates both a superuser named postgres and a system user named postgres.

Therefore, when you need to do something with Postgres as the built-in superuser, you have two options:

1. You may sudo su - postgres to become the postgres system user and execute your command (createdb, psql, etc). Because the system user has the same name as the database superuser, your command will connect as the appropriate account.
2. You may specify the username to execute as with the -U switch, eg psql -U postgres ....

Depending on your Postgres server’s authentication settings, you may be required to enter a password with either or both connection methods.

Hi,

I’m using Visual Studio 2005 Pro and SQLExpress that comes with it.

I have my program running fine in XP Pro OS using a window user «Glen» (Computer administrator) with Administrator rights.  This means that I installed VS 2005 using this window user «Glen»

I created another windows user «TestUser» (Limited account) in the same physical PC.

I tried to run the program and on the part that I need to access SQL table, I got the error [CREATE DATABASE permission denied in database ‘master’]

At the same time while using «TestUser» and running sqlcmd (to check if I can connect to SQL), I also got error HResult 0x2, Level 16, State 1.

I read alot on MSDN discussions and related links but it seems that I can’t get the solution that I need.

SO HERE ARE MY QUESTIONS :

1.  Am I allowed to run my program using user «TestUser» since SQL is installed using «Glen» windows user?

2.  Do I need to add access rights to «TestUser» to allow the user to have CREATE rights? (Note : for security reason, I can add other access rights except Administrator)

Thanks in advance for all you help.

Hi,

I’m using Visual Studio 2005 Pro and SQLExpress that comes with it.

I have my program running fine in XP Pro OS using a window user «Glen» (Computer administrator) with Administrator rights.  This means that I installed VS 2005 using this window user «Glen»

I created another windows user «TestUser» (Limited account) in the same physical PC.

I tried to run the program and on the part that I need to access SQL table, I got the error [CREATE DATABASE permission denied in database ‘master’]

At the same time while using «TestUser» and running sqlcmd (to check if I can connect to SQL), I also got error HResult 0x2, Level 16, State 1.

I read alot on MSDN discussions and related links but it seems that I can’t get the solution that I need.

SO HERE ARE MY QUESTIONS :

1.  Am I allowed to run my program using user «TestUser» since SQL is installed using «Glen» windows user?

2.  Do I need to add access rights to «TestUser» to allow the user to have CREATE rights? (Note : for security reason, I can add other access rights except Administrator)

Thanks in advance for all you help.

Вопрос:

Ответ:

Причина проблемы в том, что учетная запись, под которой база данных загружается из резервной копии, не имеет на это прав, т.к. не является администратором сервера SQL.

Администратором сервера баз данных, как правило, является пользователь, проводивший установку SQL Server. Он может назначить других пользователей администраторами сервера баз данных как при установке SQL Server, так и позднее путём присоединения их к предопределенной роли SQL Server «sysadmin».

Для решения проблемы необходимо назначить права администратора сервера SQL учетной записи, под которой загружается база данных, или загрузить базу данных из резервной копии с учетной записи пользователя, имеющего соответствующий статус.

Привет!
Столкнулся с проблемой, которую не могу понять, и как следствие, решить. Устанавливал на ubuntu Rails и всё к нему прилагающееся. И требовалось мне установить postgreSQL, и сделать это локально. И на этом моменте всё плохо. Следуя инструкциям, добавил:

$ export DATABASE_URL=postgres:///$(whoami)

whoami — в моём случае lord. После этого мне нужно:

$ bundle exec rake db:create db:migrate

Ожидаемый результат:

== 20140707111715 CreateWidgets: migrating ====================================
-- create_table(:widgets)
   -> 0.0076s
== 20140707111715 CreateWidgets: migrated (0.0077s) ===========================

Фактический:

PG::InsufficientPrivilege: ERROR:  permission denied to create database
: CREATE DATABASE "ruby-getting-started_development" ENCODING = 'unicode'
/home/lord/.rvm/gems/ruby-2.3.4/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `async_exec'
....
Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "pool"=>5, "database"=>"ruby-getting-started_development"}
PG::InsufficientPrivilege: ERROR:  permission denied to create database
: CREATE DATABASE "ruby-getting-started_test" ENCODING = 'unicode'
/home/lord/.rvm/gems/ruby-2.3.4/gems/activerecord-...
Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "pool"=>5, "database"=>"ruby-getting-started_test"}
rake aborted!
ActiveRecord::NoDatabaseError: FATAL:  database "ruby-getting-started_development" does not exist
....
/home/lord/.rvm/gems/ruby-2.3.4/bin/ruby_executable_hooks:15:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

В интернете залез в дебри, но так и не смог решить эту проблему.