Re: How do I find I am administrator?

From: Sunny (sunny_1178_at_hotmail.com)
Date: 04/06/04 

Date: Tue, 6 Apr 2004 08:54:00 -0500

"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:#CzPhl4GEHA.3772@TK2MSFTNGP12.phx.gbl...
> 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>
I selected MyTestDB and ran the store proc and it returns 3 records,
extracts from the query results:

GroupName DefDBName
db_owner master
db_accessadmin master
db_ddladmin master

I believe I have admin rights to MyTestDb.
> If you have admin rights then execute the below command from Master
> database.
>
> sp_helplogins <login_name>

Then I selected master database and ran same sp. I got message "User does
not have permission to perform this action."

What is that means. I do not have admin rights to whole server?

> 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 package admin is different than server adminn?
>
> 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

Thank you very much for providing detail information.
>
>
>
>
> "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?
> >
> >
>
>

Relevant Pages

  • Re: New to SMS - have a Collections question.
    ... local admin of both the SMS server and the server the database is on. ... However this is a security problem. ... Access to objects is based on Security Rights (if you scroll down the ...
    (microsoft.public.sms.admin)
  • Re: Admin with no Rights to Active Directory
    ... Anyone with local logon rights to a DC is in position to escalate their ... local admin on DCs, they can totally escalate to whatever they want. ... Joe Richards Microsoft MVP Windows Server Directory Services ... >>Joe Richards Microsoft MVP Windows Server Directory Services ...
    (microsoft.public.exchange2000.active.directory.integration)
  • (kein Betreff)
    ... i am the new net admin of a lab,which has a homepage/webserver on a RHEL ... there are three persons,who should do a homepage editing on the ... blade server with RHEL 3 ... index.htmlhas all kind of rights: ...
    (RedHat)
  • Homepage editing problem
    ... i am the new net admin of a lab,which has a homepage/webserver on a RHEL ... there are three persons,who should do a homepage editing on the ... blade server with RHEL 3 ... index.htmlhas all kind of rights: ...
    (RedHat)
  • Re: How do I find I am administrator?
    ... That depends up on the type of authentication you are using to access SQL ... If you have admin rights then execute the below command from Master ... enterprise manager on server where sql 2000 server is installed? ...
    (microsoft.public.sqlserver.server)
Loading