List Of Users Access By Database

Mar 31, 2004

Hello,

is there a master table that i could querry to buiild a report on the users who have acces to the various databases on the SQL server. I am trying to use master.dbo.syslogins but that is not generating what i need.

thak you all in advance,

Simon

View 2 Replies


ADVERTISEMENT

List All Users Connected To Database

Dec 14, 2007

Hi,

I need to be able to list all User connected to a particular database, after doing a bit of playing I have writen a simple view in the database to show this information which looks like

select spid, status, loginame, hostname, blocked, db_name(dbid), cmd from master..sysprocesses where db_name(dbid) = 'AutoCost2008

But my problem is that as this needs to be run from an application where the user is logged on as a standard user and therefore when this is run it only shows the current user, I am not sure what permissions I need to give this login to allow them to view all users connected to this database without giving them full Admin permissions, can anyone please help.


Thanks,


Gavin,

View 3 Replies View Related

Security Report - List Of All Active Users In Database With Their Privileges

Aug 28, 2014

I am looking to write a script that would give the list of all active users in a database with their privileges.

Sample would look something like this.

Login User Schema IsdbOwner canWrite canRead
xyz xyz dbo N Y Y

View 2 Replies View Related

Users Cant Access New Database

Dec 22, 2004

EMERGENCY 911 HELP PLEASE

Ok I created a database SQL is the engine and Access XP is the gui. When the users try to access the databae they get error message, it opens up but they cant open the forms for some reason. I was wondering if this had to do with me have Access XP and them having Access 2000, but I highly doubt it because when I had a user log on to my machine (which has access xp) they still were not able to access the forms. Can someone help me out PLEASE PLEASE PLEASE... this is so frustrating :(

One thing I'm noticing is that the users connection keeps dropping???

View 12 Replies View Related

List Users Then Disconnect Users

Jun 4, 2008

I want to be able to list all users connected/logged in a specific database and disconnect them all or a certain user.

can this be done in SQL and if so how?

View 1 Replies View Related

SQL 2012 :: Database Access From Multiple Windows Users?

Jun 3, 2014

I have been using the software, and it has been working fine (on windows user A). Now, I have created another windows user (User B), and would like to use the same software/database. The software launches fine (User B), but cannot access the created SQL database (created with user A)

How do I setup the database to allow access from all users on the same PC?

View 2 Replies View Related

Deny Users Access To Database Via Management Studio

Mar 4, 2008

Is there a way to deny the users the ability to open a server via Management Studio but still allow remote connections.

In my program I need an admin login to do various things. I am using the sa login and setting the password on install of Sql Express. But, if someone changes the password for the sa login after installation and I have the login for sa hard coded in my program, then everything will break. Is there a way to make sure that no one can change the sa password?

View 4 Replies View Related

List Of Users From Different Dbs

Jan 21, 2007

I am trying to get list of users on different dbs located on different servers.Currently i get them manualy by going on each db and copy the users to excel sheet.I tried to use sysusers, but i needed status of their account, created . Is there any easy way where i can pull list of users from all dbs from at once.I also need to exclude dbo accounts ans sa accounts if possible

View 1 Replies View Related

List Of Users?

Feb 14, 2005

How can i get a list of user that have access to all my databases?


i know how to view them but i need to output them to a text file or excel.

View 2 Replies View Related

Getting A List Of Users

Apr 4, 2008

Say I had a "typical" user table such as:

USerTable
---------
enduserid
user_name
password
firstname
lastname
...

Say this table grows very large, what would be a good way to fetch a list of users that was configurable to bring back all or some of the users ? How about a procedure that uses a range of user id's. So if you wanted ALL of you users, you just use a range of inputs that span the entire range.

comments ?


CREATE PROCEDURE EndUsers_Select
@lowuser int,
@highuser int

AS


SELECT
eu.FirstName
,eu.LastName
,ci.Email
FROM UserTable eu
JOIN ContactInformation ci ON eu.ContactInformationID = ci.ContactInformationID
WHERE EndUserID < @highuser AND EndUserID > @lowuser

View 2 Replies View Related

How To Find Out List Of Users

Aug 4, 2015

Also , is it true that Grants to service accounts should go through roles as it is against audit & compliance standards? If yes, than how to find out the list of users who has direct grant to a service account ?

- Then how to revoke this grant from service account and than how to grant through the role ?
- Is there a script that i can run and find the list of users in each SQL server instance ?

View 0 Replies View Related

List Of SQL Server Users

Jul 23, 2005

Is there any method by which i can get the list of all sql server users?

View 1 Replies View Related

List Of Connected Users

Mar 7, 2008

sorry about asking basic question, just slipped out of my mind,
how to get the list of currently connected users on one database and on whole server in sql server 2005

thanks,

View 9 Replies View Related

Active Directory + List Users

Oct 25, 2007

I neet save user login form active direcotry to databases. How I can make that?

View 1 Replies View Related

List Of Users + Roles + Rights

Feb 27, 2004

How can I generate a list/view of all users/groups with appropriate roles and rigths?

View 3 Replies View Related

Get List Of Users Not In A Specific Role

May 30, 2008

ere is the make-up of the tables:

[dbo].[PortalUser](
[PortalUserID] [bigint] IDENTITY(1,1) NOT NULL,

...

[dbo].[Role](
[RoleID] [bigint] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](250) NOT NULL,
[IsActive] [bit] NOT NULL CONSTRAINT [DF_Roles_IsActive] DEFAULT ((1))
...

[dbo].[PortalUserRole](
[PortalUserRoleID] [bigint] IDENTITY(1,1) NOT NULL,
[PortalUserID] [bigint] NOT NULL,
[RoleID] [bigint] NOT NULL,
[IsActive] [bit] NOT NULL CONSTRAINT [DF_PortalUserRole_IsActive] DEFAULT ((1))

I'm asking to get a list of portalUsers that do not have a PortalUserRole records for the rolename I'm checking against. And don't ask me why the person who coded this is searching on rolename not ID. But this is how we're doing it for now.

View 6 Replies View Related

How To Get List Of Windows Users And Groups?

Jan 9, 2008

I want to map users/groups of a .NET application which uses MS SQL Server to Windows users/groups. Then grant pemission to the Windows users/groups to access the MS SQL Server.

If possible, I want to list Windows Users and Groups regardless of whether Active Directory is used or not.

View 1 Replies View Related

Why Out Of The Blue Would VPN Users Be Unable To Connect To Database And Local Users Are Unaffected?

Mar 6, 2008

I have had this issue just pop up. I have local users who can connect fine, but my users that require connection by VPN cannot connect. I get the server not available or access denied error. I did confirm that the VPN'ers are connected to the network correctly and can see that their shares and mappings are correct. Any ideas? Thanking you all in advance!!

View 6 Replies View Related

How Can I Create A List Of Users Permissions Daily

Aug 16, 2004

I need to be able to set up a table listing users permissions, this needs to be run daily and then notify me of any changes without using the auditing or profiler software.


Any ideas?? :eek: :eek: :confused:

View 3 Replies View Related

Users&#39; Access Linked Table From ACCESS To SQL 7.0 By ODBC

Jan 12, 2000

Hi Everyone,

I have set up a link from ACCESS to a SQL 7.0 database using ODBC (File DSN saved on a shared DRIVE). The link works well only from the workstation where the link was created. But How can I create a link so a group of users can view the linked table in ACCESS without type a password? Any suggestion is appreciated.

Lunjun

View 2 Replies View Related

Reporting Services :: Populate Parameter List Of Users

Aug 18, 2015

I have a report where a user selects a AD Global Group.  Then I have another parameter that populates with the members of that group.  My problem is the userlist parameter isn't populating.  If I hard code a Global group name it works, but it isn't getting the Global Group parameter when I use @GlobalGroup.

SELECT sAMAccountName, displayName, distinguishedName
FROM 'LDAP://DC=xxx,DC=xx,DC=xx,DC=xx,DC=xx,DC=xx'
WHERE objectCategory = 'Person' AND objectClass = 'user' AND
memberOf = 'CN=@GlobalGroup,OU=Groups,OU=SCSM,OU=Applications,DC=xxxx,DC=xx,DC=xx,DC=xx,DC=xx,DC=us'

View 5 Replies View Related

Allowing Users To Type In Characters In A Drop Down List?

Feb 6, 2007



is this even possible in reporting services? I already deployed reports for our client using Reporting Services 2000, one of their complaints was that the dropdownlist of the reports contains a very long list of data, this list cannot be shorten since all data are required. Is there a way to let the users type in characters, not only one character to find the exact data they want. The data in the drop down list are needed because these data are parameters.



Are there any web based reporting tools which can provide this kind of requirement?

View 1 Replies View Related

List Groups That Have Access To Application And Use Grid Format To Show Access To Specific Tables

Jun 23, 2014

i am currently working on designing a database for a bank as a school project for my database class. We have to draw up an entity relationship diagram, Sql tables, database size estimate etc. I am currently working on the security portion of the project. I need to list the groups that have access to my application and use a grid format to show access to specific tables.

I am currently working on designing a database for a bank as a school project for my database class. We have to draw up an entity relationship diagram, Sql tables, database size estimate etc. I am currently working on the security portion of the project. I need to list the groups that have access to my application and use a grid format to show access to specific tables.

Role Loans Payments Transactions Accounts Customer Emplo
Database Admin SUID SUID SUID SUID SUID SUID
Branch Manager SUI SUI SUI SUI SUI SUI
Internal Auditor S S S S S S
Loan Officer SUID SUI SUI S S
Tellers S S S S SU
Customers U

View 1 Replies View Related

SQL Server Admin 2014 :: List Of Users That Accessed A Table

Jul 22, 2015

I'm trying to find out what tables are being used in a Database.

I don't want the last User but the User and the Dates.

I have a script that return the last user but that is not going to work.

The following script returns the last user but not all users and the Login Name:

ITH LastActivity (ObjectID, LastAction) AS
(
SELECT object_id AS TableName,
last_user_seek as LastAction
FROM sys.dm_db_index_usage_stats u
WHERE database_id = db_id(db_name())

[Code] .....

View 2 Replies View Related

Report Model Not Allowing Users To Filter Using A Pick List

Jan 9, 2008

I have a MSSQL Report Services Report Model set up to allow users to create their own ad hoc reports. The data source for my model is a Named Query that queries a MS SQL view that actually pulls data from a series of tables & other views. When you create a report from this model and attempt to filter the data some of the fileds will provide you with a pick list to select which values you would like to filter on and other fields do not provide you with a pick list but require you to enter the data directly that you wish to filter on. Most of the data fields that I am trying to filter on are varchar fields and like I said some will create a pick list for you to selet from and others will not. This all seemed to start after I changed my data source to a Named Query rather than having my data source as the MS SQL View directly. I did this becuase it seemed that anytime I had to make a change to the views that the data source pulled from it would mess up any existing reports that had been created and this does not happen if I use a named query. I have gone crazy trying to figure this one out so any ideas would be greatly appreciated!

View 1 Replies View Related

Difference Between Database -- &&> Users And Security --&&> Users

Nov 28, 2006

Hi Team,

In SQL Enterprise Manager, when we expand "Database -->Users", we see the

users there. When we expand "Security --> logins" we see the same users there.

Can you differentiate these two.

Thanks

Santhosh

View 1 Replies View Related

Users' Access Through ADO

Sep 20, 2004

Hi,
I'm writing a program to access a SQL server and my problem is that if I use a user that isn't an administrator the login is failed.

It specifies the " DomainUserName "

Maybe it wouldn't have bothered me so if I didn't see it working on the last server I had. Unfortunatly, that one was formatted and I wasn't the one installing the SQL server on it.

Does anybody know how to make the SQL server more tolrant to users?

Thanks,
Chen.

View 1 Replies View Related

MS Access Concurrent Users

Nov 7, 2000

Hi,

Does anyone know is MS Access has any limited no of users, or how many concurrent users MS Access has?

Thanks

View 2 Replies View Related

Users Limited Access By IP

Sep 25, 2007

Hiya - this might be a bit of a simple question but please bear with me! I have looked reasonably hard for this but can not find an answer:

I have an MSSQL 2000 server running on PC-A and would like to limit certain users (e.g. admin) to be only able to logon when using the actual PC-A machine.

I am aware that you can acheive this in MySQL with the "insert into user (host, user, password) values (localhost, username, password);" command. Is there an equivalent way to do this in MSSQL?

Thanks for your help,

Alistair.

View 1 Replies View Related

Allowing Users Access To Their DB Only?

Apr 6, 2004

Hey all.

I'm trying to set up SQL Server so that people with Enterprise Mgr can create a DB registration to their DB only (sql.yoursite.com). Are there any tutorials out there for doing this?

Thanks for the help!

View 3 Replies View Related

Access For Users To SQL Server Read Only

Jan 29, 2001

I have SQL Server 7 database & I need to create some interface between users & database to let users see what is in the database, but not let them change or destroy data. Do I need to create some other database in-between users & the original database? Users can't program & want access to all data.management doesn't want to create a replication of the database. They want to let users have access through MS Word or Access. What could you advise me?

View 1 Replies View Related

Can I Access SQL Login Users In ASP.Net Application

Sep 28, 2005

Hello All,

View 3 Replies View Related

Access Forbidden: Too Many Users Are Connected

Oct 22, 2007

I have a web application that runs on IIS on Windows XP professional. I have reached the max number of connections to the IIS website. So, I tried the approach of disabling HTTP Keep-Alives.


All is fine and dandy until my Business Intelligence Studio report project attempts to set the parameters for a report using report viewer at which point I get the following error message:


"The request failed with http status 401: access denied."


How can I fix this? I have posted this over at the asp.net forums, but I figured I would check here to see if anyone else has solved this problem.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved