Re: How do I find I am administrator?
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 04/06/04
- Next message: K. Reichold: "NetIQ Diagnostic Manager - alternative one?"
- Previous message: Sunny: "How do I find I am administrator?"
- In reply to: Sunny: "How do I find I am administrator?"
- Next in thread: Sunny: "Re: How do I find I am administrator?"
- Reply: Sunny: "Re: How do I find I am administrator?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 6 Apr 2004 09:13:53 +0530
Hi,
How do I find I am in admin group or not? How do I find what rights I am
given?
That depends up on the type of authentication you are using to access SQL
server. If you are normal user and you are using
SQL Authentication, then you can run sp_helplogins to get all the
informations;
How to check:
Login to query analyzer and go to the database you have prev and execute
sp_helpuser <user_name>
If you have admin rights then execute the below command from Master
database.
sp_helplogins <login_name>
Can I make changes on package without admin rights ?
You can create packages, but you can modify the pckage with out knowwing the
package admin password.
Is there any limitation in enterprise manager as client tools and
enterprise manager on server where sql 2000 server is installed?
No, there is no limitations.
Thanks
Hari
MCDBA
"Sunny" <sunny_1178@hotmail.com> wrote in message
news:uimzBx0GEHA.2436@TK2MSFTNGP09.phx.gbl...
> This is the first time I will be using SQL server although I have good
> experience in FoxPro and ACCESS database, I have limited knowledge of SQL
> server.
>
> We have installed SQL server 2000 on WIN2K. Our IT people has installed
> Enterprise Manager on my win2000 workstation. How do I find I am in admin
> group or not? How do I find what rights I am given?
>
> Can I make changes on package without admin rights or do I have to change
> package physically from server where sql server is installed? Is there any
> limitation in enterprise manager as client tools and enterprise manager on
> server where sql 2000 server is installed?
>
>
- Next message: K. Reichold: "NetIQ Diagnostic Manager - alternative one?"
- Previous message: Sunny: "How do I find I am administrator?"
- In reply to: Sunny: "How do I find I am administrator?"
- Next in thread: Sunny: "Re: How do I find I am administrator?"
- Reply: Sunny: "Re: How do I find I am administrator?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
