Re: Users Role

Thanks but I need one query through which I can findout that becauase I am
creating a cursor and at the runtime I will set the rolname into
variable....

Thanks
"samsøe" <samse@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3BB59877-FADB-4BDB-B3C1-ADEB08A57E5F@xxxxxxxxxxxxxxxx
>
>
> "Rogers" wrote:
>
>> I want to findout the users and its role in specific database like that
>> user
>> has db_owner rights, I want one query that I can execute in the Query
>> Analyzer and findout the role.
>>
>> Thanks
>>
>>
>>
> SQL 2000:
> try
> exec sp_helpuser or altrenatively
> exec sp_helpuser <username>
>
> change the database context to the relevant database


.

Relevant Pages

  • Users Role
    ... has db_owner rights, I want one query that I can execute in the Query ... Analyzer and findout the role. ...
    (microsoft.public.sqlserver.clients)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)
Loading