That line isn’t actually adding an users to sudoers, merely making sure that the wheel group can have passwordless sudo for all command. As for adding users to /etc/sudoers this is best done by adding users to necessary groups and then giving these groups the relevant access to sudo. This holds true when you aren’t … Read more
Without a home directory sudo useradd myuser With home directory sudo useradd -m myuser Then set the password sudo passwd myuser Then set the shell sudo usermod -s /bin/bash myuser
Reference taken from this Article ! Script to Create Read-Only user: CREATE ROLE Read_Only_User WITH LOGIN PASSWORD ‘Test1234’ NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION VALID UNTIL ‘infinity’; Assign permission to this read only user: GRANT CONNECT ON DATABASE YourDatabaseName TO Read_Only_User; GRANT USAGE ON SCHEMA public TO Read_Only_User; GRANT SELECT ON ALL TABLES IN SCHEMA public … Read more
SELECT 1 FROM pg_roles WHERE rolname=”USR_NAME” And in terms of command line (thanks to Erwin): psql postgres -tXAc “SELECT 1 FROM pg_roles WHERE rolname=”USR_NAME”” Yields 1 if found and nothing else. That is: psql postgres -tXAc “SELECT 1 FROM pg_roles WHERE rolname=”USR_NAME”” | grep -q 1 || createuser …
I’ve run something like this in the past. LDAP is your best bet for centralized accounts. This is reasonably standard, and should be easy to set up. The client is merely a matter of installing a few packages (ldap-utils, libnss-ldap, and libpam-ldap), and editing /etc/pam.d/common-(everything). You’ll need to add a line like <type of file … Read more
A posible solution is to alter default privileges for u user: Eg: alter default privileges in schema public grant all on tables to u; alter default privileges in schema public grant all on sequences to u; Description ALTER DEFAULT PRIVILEGES allows you to set the privileges that will be applied to objects created in the … Read more
In 5.7.6 and above, you should be able to use CREATE USER CREATE USER IF NOT EXISTS ‘user’@’localhost’ IDENTIFIED BY ‘password’; Note that the 5.7.6 method doesn’t actually grant any permissions. If you aren’t using a version which has this capability (something below 5.7.6), you can do the following: GRANT ALL ON `database`.* TO ‘user’@’localhost’ … Read more
Check /etc/ssh/sshd_config for allowed users list. If it is OK, the problem is more complex. Try to connect as “ssh codeuser@your-server -v”
I don’t think anybody uses NIS anymore – or at least, wants to. The fastest and easiest way to get a nice LDAP+Kerberos environment up is FreeIPA. It’s easy and light enough that I even use it at home. Red Hat’s Identity Management Guide is a great introduction to FreeIPA and will get you up … Read more