Grant permission

What is the SQL to grant all permission to DBA ?
Grant All to DBA ? Is that correct ?Is DBA a special user, like the database owner, sa, or someone in the
sysadmin role, or is it just a name you created.
If it is one of the special users, what permissions do you want to give it
that it doesn't already have?
If it's a user created name, grant all will only give all the statement
permissions, like CREATE TABLE, CREATE PROC, etc, but wont' give data access
permissions to all the objects.
You might try putting the user in the db_owner role instead.
Please clarify what you're trying to do, and also tell us what version you
are using.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Alan" <alanpltse@.yahoo.com.au> wrote in message
news:OKTL8UBeDHA.1680@.TK2MSFTNGP09.phx.gbl...
> What is the SQL to grant all permission to DBA ?
> Grant All to DBA ? Is that correct ?
>|||Sorry, I need to tell you that this is the exercise from my course:
Grant all permission to the database administrator.
What T-SQL should be used ?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:Oq$f4hBeDHA.2324@.TK2MSFTNGP12.phx.gbl...
> Is DBA a special user, like the database owner, sa, or someone in the
> sysadmin role, or is it just a name you created.
> If it is one of the special users, what permissions do you want to give it
> that it doesn't already have?
> If it's a user created name, grant all will only give all the statement
> permissions, like CREATE TABLE, CREATE PROC, etc, but wont' give data
access
> permissions to all the objects.
> You might try putting the user in the db_owner role instead.
> Please clarify what you're trying to do, and also tell us what version you
> are using.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Alan" <alanpltse@.yahoo.com.au> wrote in message
> news:OKTL8UBeDHA.1680@.TK2MSFTNGP09.phx.gbl...
> > What is the SQL to grant all permission to DBA ?
> >
> > Grant All to DBA ? Is that correct ?
> >
> >
>|||My questions still remain? What is the database administrator? What is her
login and user name?
Is it the sa? If so, this is a meaningless question because the sa already
has full permissions to do everything.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Alan" <alanpltse@.yahoo.com.au> wrote in message
news:#wsDp2LeDHA.3096@.TK2MSFTNGP11.phx.gbl...
> Sorry, I need to tell you that this is the exercise from my course:
> Grant all permission to the database administrator.
> What T-SQL should be used ?
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:Oq$f4hBeDHA.2324@.TK2MSFTNGP12.phx.gbl...
> > Is DBA a special user, like the database owner, sa, or someone in the
> > sysadmin role, or is it just a name you created.
> > If it is one of the special users, what permissions do you want to give
it
> > that it doesn't already have?
> >
> > If it's a user created name, grant all will only give all the statement
> > permissions, like CREATE TABLE, CREATE PROC, etc, but wont' give data
> access
> > permissions to all the objects.
> > You might try putting the user in the db_owner role instead.
> >
> > Please clarify what you're trying to do, and also tell us what version
you
> > are using.
> > --
> > HTH
> > --
> > Kalen Delaney
> > SQL Server MVP
> > www.SolidQualityLearning.com
> >
> >
> > "Alan" <alanpltse@.yahoo.com.au> wrote in message
> > news:OKTL8UBeDHA.1680@.TK2MSFTNGP09.phx.gbl...
> > > What is the SQL to grant all permission to DBA ?
> > >
> > > Grant All to DBA ? Is that correct ?
> > >
> > >
> >
> >
>|||I think I need to clarify with my teacher.
> My questions still remain? What is the database administrator? What is her
> login and user name?
> Is it the sa? If so, this is a meaningless question because the sa already
> has full permissions to do everything.