The tag has no wiki summary.

learn more… | top users | synonyms

-1
votes
0answers
18 views

dynamic table can't be accessed by the users [closed]

i have created a dynamic table within the stored procedure and granted access permissions for the particular table and stored procedure to the corresponding users and it will get from the out variable ...
-1
votes
2answers
42 views

How is SQL used from an end-user perspective? [closed]

So I've been learning database manipulation and design and using SQL, but surely a secretary of a company wouldn't be using SQL to directly enter things into the database, so how does that work? For ...
1
vote
1answer
40 views

MySQL service stops after trying to grant privileges to a user

I am using MySQL 5.6, I was trying to create a super user for specific database but I got ERROR 1396 (HY000): Operation CREATE USER failed for 'superuser'@'%' Then I thought maybe there is already ...
1
vote
0answers
14 views

Auditing AS 400 DB2 library user access

As part of the testing to check for authorized users having access to applications and libraries on AS 400 systems, I need help to figure out a list of users having access to applications hosted on ...
0
votes
1answer
27 views

Remove profile from user

How do I clear user's profile? I found how I can drop the profile (also using CASCADE), but I want to keep the profile and just remove it from the user.
0
votes
1answer
21 views

Why does mysql allow me to enter password for non existing mysql user

My mysql server has 2 users - root robb But when I try to login with another user it let's me enter password - hussain@magic-laptop:~$ mysql -u jon -p Enter password: Shouldn't it give an error ...
0
votes
0answers
29 views

I need a listing of all of the oracle users and their access levels to the database

Have already found great note oracle - list users with access to certain tables But can someone help me to combine these select statements to get listing of all of the oracle users and their access ...
1
vote
1answer
57 views

Handling user logins while using a multiple schema design to support multi-tenancy

I'm creating a web application (in PHP and PostreSQL) that will be used by organisations and their staff and I want to use multiple schemas to support multi-tenancy. There will be one database and I ...
0
votes
0answers
12 views

Please explain SYSCS_UTIL.SYSCS_CREATE_USER() function

Can someone please explain to me how SYSCS_UTIL.SYSCS_CREATE_USER() works? I tried adding a new user like this: SYSCS_UTIL.SYSCS_CREATE_USER('user', 'someP@ss'), and it gave an exception Error code ...
0
votes
0answers
14 views

Usermanagement and a database pr user

Is there any easy way to manage users? Let's say, I need another user called user2. This user needs a database called user2 aswell - With only privileges to THIS database. It's easy to do, just by ...
3
votes
2answers
202 views

Database User not reported as orphaned after Windows login dropped

I have dropped a SQL Server Windows Login. I then ran the below code to check for orphaned database users. However, the database user corresponding to the dropped Windows login does not appear as an ...
0
votes
1answer
37 views

users and roles in mongodb

Following users are created in mongodb. First user created with name "user" having read write role for "project" database use project db.createUser( { user: "user", pwd: "user123", ...
1
vote
1answer
42 views

Does PostgreSQL allow multiple grantees in GRANT commands?

Looking at the PostgreSQL docs it seems that the GRANT command only grants to a single user or role. In fact it doesn't seem to be PostgreSQL alone. Isn't possible to do something like GRANT SELECT ...
0
votes
1answer
70 views

What is the meaning of different roles available(DB Admin etc.)

I have recently installed MySQL and also created the basic user as scott but my doubt is regarding the roles. I don't understand different roles available for the user which I have created. I want ...
1
vote
1answer
481 views

Error Code: 1133. Can't find any matching row in the user table

Im reading O'Relly "Learning MySQL" and it says that you can create a user in MySQL by doing just this: mysql> GRANT ALL ON *.* TO 'jill'@'%.invyhome.com' IDENTIFIED BY 'the_password'; Query OK, 0 ...
2
votes
1answer
444 views

Create new Read Only user on DB2 on the whole database

I am an oracle/sql server DBA having limited knowledge in IBM DB2. We have DB2 9.7 fp4 running on AIX 6. I would like to create a new user and grant him READ only privilege on a particular database. ...
1
vote
1answer
62 views

Mongodb sharded cluster backup user issue

We're using a simple python script to backup our mongodb cluster. the script connects to each mongod instance via ssh, and performs mongodump, all without requiring user/pass ever since we started ...
0
votes
1answer
81 views

What do columns with a “dot” mean when listing Sql Server user permissions using sp_helprotect?

I have a DB that I did not setup and I used sp_helprotect to list the permissions, the output is as in the image below. I don't understand the dot's in the Owner, Object and Column columns. And I ...
0
votes
1answer
93 views

Storing a music playlist, best approach?

I am working on a web project that creates playlists online based on youtube links. My question is how do I store a playlist on MYSQL. What I was thinking about doing was having a table with ...
0
votes
1answer
46 views

Restricting Insert and Update to functions

We have a function in postgresql that inserts some rows in a table and updates some other rows based on an input provided by the user. Is it possible to somehow execute the function without giving ...
-5
votes
1answer
789 views

How to clone a user in SQL Server 2008 R2?

I am a newbie in MS SQL Server, and just got assigned a new task to clone 5 users from an existing user in a Database. Could anyone help me? P.S.: It would be great if the step or method is in GUI. ...
2
votes
0answers
360 views

Adding group rights in db2 for a stored procedure

I have a list of user accounts on AIX server, where the db2 database resides in. The user accounts all belong to a specific group which I can confirm from aix shell. User accounts work in DB2. ...
2
votes
1answer
57 views

How to find out if anything is running as or relies upon a user account in anyway before removing it?

Running SQL Server 2008. So I need to get around to removing an old users account, but I'm worried that just disabling or deleting it right away might cause some things to stop working properly if ...
0
votes
0answers
62 views

“Database user”, “application user” and “person” and mapping between them in PostgreSQL

In my PostgreSQL database I have a table for people and a table for users, connected with a 1:0..1 relationship. The "user" table can serve as a list of users for the client application, but not for ...
1
vote
1answer
55 views

How dangerous is it to have a user's password in plaintext in a cgi script?

I am setting up a MySQL database and am providing a web interface for it. Now, the DB is extremely simple and the interface just runs certain SELECT statements. I have created a user for my script to ...
3
votes
1answer
324 views

SQL Script to Drop old AD logins, Inactive SQL Logins and all related Users

Related Question: SQL Server script to delete accounts no longer in Active Directory Whilst the above question points out the rather handy sp_validatelogins procedure, i'd like to extend this ...
1
vote
1answer
87 views

What is the purpose of a user's default database?

As I understand it the default database is specified so that in case you don't specify one in the connection string, it will know where to start. Is this correct? I've never seen a connection string ...
-1
votes
1answer
191 views

Approximate MySQL Query Time For A Where Clause On A 10 Million Records Table

I'm looking forward to designing a database (in MySQL) but before I start I need to have some calculations to make sure that my application will remain efficient even if there are 10 Million+ rows ...
-1
votes
2answers
4k views

How to Create users in sql server for accessing only one database using Management Studio [closed]

How to Create users in sql server 2008 R2 for accessing only one database using Management Studio. regards, salman
1
vote
1answer
201 views

sp_setapprole and creating users / logins

We have set up SQL Server and our Application in such a way that an SQL Server login has … well no permissions when accessing the database using any tool, except our application. This is needed ...
0
votes
0answers
82 views

How to let another use a LocalDb Instance and MDF combination previously used by LocalSystem or another user

I have a software installation that includes a Topshelf service and an MVC4 web application. Both need to access the same LocalDb MDF. The development version runs as our users. The installed version ...
0
votes
0answers
54 views

drop user '' in h2 database

I currently use h2 database and started creating new users with different grants, but by default there is a user namen '' with the password '' in the database with all privilages, which is a security ...
1
vote
0answers
33 views

Moved database to new server, not sure about NT AUTHORITY\* users

I just moved database to new instance of SQL Server (SQL Server 2012 Web from Amazon EC2) and am now cleaning up database users. I am not sure if/why these 2 users are needed (they exist in original ...
5
votes
1answer
304 views

Fastest way to get current user's OID in Postgres?

I am thinking of storing the user's OID in the "owner" column of a table, so I don't have to do anything if they change their username. I understand one can use pg_has_role() with OIDs, so that's ...
2
votes
2answers
1k views

How to grant permission to new user created in mysql?

I want to create new user and want to give them specific permission like inset, update and delete. But how to create new user and give them permission i don't know. Any help please.
0
votes
2answers
77 views

Grant access on a database to all users

I have a global database, as I all users should have access to it. Is it possible to grant permission on a database to all users? something like GRANT ALL ON my_database.* TO *@localhost; Even (for ...
2
votes
2answers
621 views

How to get all roles that a user is a member of (including inherited roles)?

Let's say I have two Postgresql database groups, "authors" and "editors", and two users, "maxwell" and "ernest". create role authors; create role editors; create user maxwell; create user ernest; ...
1
vote
1answer
83 views

How to manage users and collections in MongoDB? [duplicate]

Im triying to create users in a database in mongo, I want to lock the usage of te collections for some users, I'll give an example: Lets say that I actually have a db with 3 collections: Books, ...
0
votes
1answer
496 views

User creation and rights to import a dump

I'm having problems creating an instance of Oracle 10.2.0.4 and importing a dump from other environment. I'm using Oracle under AIX. I used a ksh script and everything goes right except when creating ...
2
votes
1answer
63 views

Database structure for multiple users sharing one dataset, but also many users with their own dataset

I'm building a web app with php/mysql, and I'm trying to figure out how to set up multiple users sharing data. Here's the best analogy I can come up with on what I'm trying to do: You have a ...
1
vote
1answer
92 views

db2 connecting to a db via alias and storing user name and password

I created a TCP node and I catalogued a db into it. The catalogued db needs user name and password to be accessed. Is there anyway I can store username and password in the cataologue (or other way)? I ...
3
votes
4answers
388 views

How to rollback changes made to the database by a specific user?

In mssql, is it possible to rollback changes made by a specific user to the database? For example if that user ran an update query and did not write begin transaction before, is it possible to revert ...
1
vote
1answer
239 views

How To Hide Schema from user

I have DB with 2 schemas: A and B. B schema's procedures use A schema's procedures. I need to create user, which will not be able to see A schema. This user can use only B schema, but i want to let ...
1
vote
1answer
137 views

User switching accounts, can't log into MS SQL Server anymore [closed]

First a bit of background, for good or bad, we don't keep one user account attached to one person. The user accounts are matched to their position. For instance the CEO would have a userid of CEO. ...
2
votes
2answers
70 views

How to revert multiple impersonations?

When there are nested impersonations (as in exec as user = 'user1'; exec as user = 'user2'; exec as user = 'user1';), is there a way to revert all of them without having to use the revert command ...
0
votes
1answer
1k views

How to see profile assigned to a user

Let's say i have created a user as 'TEST_USER', and then i assigned a profile to it. Now how can i see for TEST_USER which profile has been assigned? I want some query that will check what profile a ...
1
vote
2answers
124 views

Audit table insert restriction

So I'm trying to create my own audit table for some user management analysis and stumbled across a little problem. I use this trigger CREATE OR REPLACE TRIGGER usr_t_audit_user_alnd AFTER LOGON ...
1
vote
2answers
216 views

How to create root user after running mysql_install_db?

I'm installing MySQL on ubuntu and I changed the data directory. I created new data files using mysql_install_db command. So now I need to access my database using root but it won't let me in. I ...
0
votes
2answers
1k views

how to join table from different database with different Users of database?

I have Two database called. Database1: host: 127.0.0.1 user: root1 pass: root1 dbname: db1 Table 1: Category ID INT(11) Primary Key Name VARCHAR(255) Database2: host: 127.0.0.2 ...
3
votes
3answers
1k views

How to know the user doing a delete action on an audit table, when using a shared login?

Background information: I'm creating a collection of audit tables to keep track of updates and deletes to a set of data tables for my app. Audit records are created via triggers. DML in my app's ...