Re: Users Access?

From: "Ben Nevarez" <bnevarez@xxxxxxx>
Date: Tue, 15 Nov 2005 22:38:26 -0800

Here you have a query that you will need to test or change for your specific
needs

select p.id, o.name from syspermissions p
join sysusers u on p.grantee = u.uid
join sysobjects o on p.id = o.id
where u.name = 'dbuser'

Ben Nevarez

"Rogers" <naissani@xxxxxxxxxxx> wrote in message
news:%23cYEWHj6FHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
>I have created one user named dbUser and gave different database access to
>that user now I want to find out which database and it's objects can access
>to that user through query analyzer, any query or idea how ?
>

.

References:
- Users Access?
  - From: Rogers

Prev by Date: Re: problem trying to save a date field
Next by Date: Re: Sql Server Locks
Previous by thread: Users Access?
Next by thread: Re: problem trying to save a date field
Index(es):
- Date
- Thread

Relevant Pages

Re: wrong query result
... And the query without where clause in subquery works fine. ... FROM systables b, (systabauth AS c LEFT JOIN sysusers AS e ON ... query without bind variables does not work too. ... (systabauth AS c LEFT JOIN sysusers AS e ON ...
(comp.databases.informix)
"Please wait" window
... I have a pretty simple VB.NET which contains some dropdown lists, a QUERY ... button, UPDATE button and datagrid. ... the database access behind the QUERY and UPDATE buttons can be a little ...
(microsoft.public.dotnet.framework.aspnet)