Does anyone know what is the statement to drop the
following permissions in QA (Not DENY).
There are too many of them to drop from the E.M.
GRANT REFERENCES , SELECT , UPDATE , INSERT , DELETE
ON [dbo].[mytable] TO [public]
GO
Thanks.
look at the REVOKE statement.
Example: REVOKE SELECT ON Budget_Data TO Mary
"Eric" wrote:
> Does anyone know what is the statement to drop the
> following permissions in QA (Not DENY).
> There are too many of them to drop from the E.M.
>
> GRANT REFERENCES , SELECT , UPDATE , INSERT , DELETE
> ON [dbo].[mytable] TO [public]
> GO
> Thanks.
>
|||Thanks...........
[vbcol=seagreen]
>--Original Message--
>look at the REVOKE statement.
>Example: REVOKE SELECT ON Budget_Data TO Mary
>
>"Eric" wrote:
DELETE
>.
>
Showing posts with label permissions. Show all posts
Showing posts with label permissions. Show all posts
Thursday, March 29, 2012
Dropping Permissions
Does anyone know what is the statement to drop the
following permissions in QA (Not DENY).
There are too many of them to drop from the E.M.
GRANT REFERENCES , SELECT , UPDATE , INSERT , DELETE
ON [dbo].[mytable] TO [public]
GO
Thanks.look at the REVOKE statement.
Example: REVOKE SELECT ON Budget_Data TO Mary
"Eric" wrote:
> Does anyone know what is the statement to drop the
> following permissions in QA (Not DENY).
> There are too many of them to drop from the E.M.
>
> GRANT REFERENCES , SELECT , UPDATE , INSERT , DELETE
> ON [dbo].[mytable] TO [public]
> GO
> Thanks.
>|||Thanks...........
>--Original Message--
>look at the REVOKE statement.
>Example: REVOKE SELECT ON Budget_Data TO Mary
>
>"Eric" wrote:
>> Does anyone know what is the statement to drop the
>> following permissions in QA (Not DENY).
>> There are too many of them to drop from the E.M.
>>
>> GRANT REFERENCES , SELECT , UPDATE , INSERT ,
DELETE
>> ON [dbo].[mytable] TO [public]
>> GO
>> Thanks.
>.
>
following permissions in QA (Not DENY).
There are too many of them to drop from the E.M.
GRANT REFERENCES , SELECT , UPDATE , INSERT , DELETE
ON [dbo].[mytable] TO [public]
GO
Thanks.look at the REVOKE statement.
Example: REVOKE SELECT ON Budget_Data TO Mary
"Eric" wrote:
> Does anyone know what is the statement to drop the
> following permissions in QA (Not DENY).
> There are too many of them to drop from the E.M.
>
> GRANT REFERENCES , SELECT , UPDATE , INSERT , DELETE
> ON [dbo].[mytable] TO [public]
> GO
> Thanks.
>|||Thanks...........
>--Original Message--
>look at the REVOKE statement.
>Example: REVOKE SELECT ON Budget_Data TO Mary
>
>"Eric" wrote:
>> Does anyone know what is the statement to drop the
>> following permissions in QA (Not DENY).
>> There are too many of them to drop from the E.M.
>>
>> GRANT REFERENCES , SELECT , UPDATE , INSERT ,
DELETE
>> ON [dbo].[mytable] TO [public]
>> GO
>> Thanks.
>.
>
Dropping Permissions
Does anyone know what is the statement to drop the
following permissions in QA (Not DENY).
There are too many of them to drop from the E.M.
GRANT REFERENCES , SELECT , UPDATE , INSERT , DELETE
ON [dbo].[mytable] TO [public]
GO
Thanks.look at the REVOKE statement.
Example: REVOKE SELECT ON Budget_Data TO Mary
"Eric" wrote:
> Does anyone know what is the statement to drop the
> following permissions in QA (Not DENY).
> There are too many of them to drop from the E.M.
>
> GRANT REFERENCES , SELECT , UPDATE , INSERT , DELETE
> ON [dbo].[mytable] TO [public]
> GO
> Thanks.
>|||Thanks...........
>--Original Message--
>look at the REVOKE statement.
>Example: REVOKE SELECT ON Budget_Data TO Mary
>
>"Eric" wrote:
>
DELETE[vbcol=seagreen]
>.
>
following permissions in QA (Not DENY).
There are too many of them to drop from the E.M.
GRANT REFERENCES , SELECT , UPDATE , INSERT , DELETE
ON [dbo].[mytable] TO [public]
GO
Thanks.look at the REVOKE statement.
Example: REVOKE SELECT ON Budget_Data TO Mary
"Eric" wrote:
> Does anyone know what is the statement to drop the
> following permissions in QA (Not DENY).
> There are too many of them to drop from the E.M.
>
> GRANT REFERENCES , SELECT , UPDATE , INSERT , DELETE
> ON [dbo].[mytable] TO [public]
> GO
> Thanks.
>|||Thanks...........
>--Original Message--
>look at the REVOKE statement.
>Example: REVOKE SELECT ON Budget_Data TO Mary
>
>"Eric" wrote:
>
DELETE[vbcol=seagreen]
>.
>
Wednesday, March 21, 2012
Drop Table permissions...
I'm thinking this can't be done, but wanted to try it anyways...
Is there any way a user can grant permission for another user to drop one of
his/her tables? Something like this:
GRANT DROP TABLE ON MYTABLE TO ALL;
We have a table which can be created by a user then left alone for a while
(data import procedure) which needs to be dropped by someone else (on the
next import, the ID numbers need to be set back to one). Thanks in advance!Using NT Authentication, set the permissions to a login based on a user
group and put both people in the group.
Bob Castleman
DBA Poseur
"Lost!" <Lost@.discussions.microsoft.com> wrote in message
news:272B4F05-D539-4F86-966B-EA74B23D7C20@.microsoft.com...
> I'm thinking this can't be done, but wanted to try it anyways...
> Is there any way a user can grant permission for another user to drop one
> of
> his/her tables? Something like this:
> GRANT DROP TABLE ON MYTABLE TO ALL;
> We have a table which can be created by a user then left alone for a while
> (data import procedure) which needs to be dropped by someone else (on the
> next import, the ID numbers need to be set back to one). Thanks in
> advance!|||Why not have each user do this at the END of his/her processing?
Also be aware that truncating the table resets Identity Values, as well as
deleting all data, without the added overhead of recording the delete in the
transaction Log. If your schema will allow the use of Truncate Table, that
might be a better option.
"Lost!" wrote:
> I'm thinking this can't be done, but wanted to try it anyways...
> Is there any way a user can grant permission for another user to drop one
of
> his/her tables? Something like this:
> GRANT DROP TABLE ON MYTABLE TO ALL;
> We have a table which can be created by a user then left alone for a while
> (data import procedure) which needs to be dropped by someone else (on the
> next import, the ID numbers need to be set back to one). Thanks in advance![/color
]|||But then they couldn't recreate the table. Why not let the user create the
table in their own namespace? Or you could have a permanent table, delete
the data from it, insert the new data and subtract the minimum value from
the new ids.
create table dbo.test
(
testId int identity,
value char(1)
)
go
insert into test (value)
values ('a')
insert into test (value)
values ('b')
insert into test (value)
values ('c')
delete dbo.test
insert into test (value)
values ('a')
insert into test (value)
values ('b')
insert into test (value)
values ('c')
declare @.offset int
set @.offset = (select min(testId) - 1 from test)
select testId - @.offset as testId, value
from test
value
-- --
1 a
2 b
3 c
Just add a job to cleanup the value every once in a while :) Tacky, but it
should work for you.
----
Louis Davidson - drsql@.hotmail.com
SQL Server MVP
Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design -
http://www.apress.com/book/bookDisplay.html?bID=266
Blog - http://spaces.msn.com/members/drsql/
Note: Please reply to the newsgroups only unless you are interested in
consulting services. All other replies may be ignored :)
"Lost!" <Lost@.discussions.microsoft.com> wrote in message
news:272B4F05-D539-4F86-966B-EA74B23D7C20@.microsoft.com...
> I'm thinking this can't be done, but wanted to try it anyways...
> Is there any way a user can grant permission for another user to drop one
> of
> his/her tables? Something like this:
> GRANT DROP TABLE ON MYTABLE TO ALL;
> We have a table which can be created by a user then left alone for a while
> (data import procedure) which needs to be dropped by someone else (on the
> next import, the ID numbers need to be set back to one). Thanks in
> advance!sql
Is there any way a user can grant permission for another user to drop one of
his/her tables? Something like this:
GRANT DROP TABLE ON MYTABLE TO ALL;
We have a table which can be created by a user then left alone for a while
(data import procedure) which needs to be dropped by someone else (on the
next import, the ID numbers need to be set back to one). Thanks in advance!Using NT Authentication, set the permissions to a login based on a user
group and put both people in the group.
Bob Castleman
DBA Poseur
"Lost!" <Lost@.discussions.microsoft.com> wrote in message
news:272B4F05-D539-4F86-966B-EA74B23D7C20@.microsoft.com...
> I'm thinking this can't be done, but wanted to try it anyways...
> Is there any way a user can grant permission for another user to drop one
> of
> his/her tables? Something like this:
> GRANT DROP TABLE ON MYTABLE TO ALL;
> We have a table which can be created by a user then left alone for a while
> (data import procedure) which needs to be dropped by someone else (on the
> next import, the ID numbers need to be set back to one). Thanks in
> advance!|||Why not have each user do this at the END of his/her processing?
Also be aware that truncating the table resets Identity Values, as well as
deleting all data, without the added overhead of recording the delete in the
transaction Log. If your schema will allow the use of Truncate Table, that
might be a better option.
"Lost!" wrote:
> I'm thinking this can't be done, but wanted to try it anyways...
> Is there any way a user can grant permission for another user to drop one
of
> his/her tables? Something like this:
> GRANT DROP TABLE ON MYTABLE TO ALL;
> We have a table which can be created by a user then left alone for a while
> (data import procedure) which needs to be dropped by someone else (on the
> next import, the ID numbers need to be set back to one). Thanks in advance![/color
]|||But then they couldn't recreate the table. Why not let the user create the
table in their own namespace? Or you could have a permanent table, delete
the data from it, insert the new data and subtract the minimum value from
the new ids.
create table dbo.test
(
testId int identity,
value char(1)
)
go
insert into test (value)
values ('a')
insert into test (value)
values ('b')
insert into test (value)
values ('c')
delete dbo.test
insert into test (value)
values ('a')
insert into test (value)
values ('b')
insert into test (value)
values ('c')
declare @.offset int
set @.offset = (select min(testId) - 1 from test)
select testId - @.offset as testId, value
from test
value
-- --
1 a
2 b
3 c
Just add a job to cleanup the value every once in a while :) Tacky, but it
should work for you.
----
Louis Davidson - drsql@.hotmail.com
SQL Server MVP
Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design -
http://www.apress.com/book/bookDisplay.html?bID=266
Blog - http://spaces.msn.com/members/drsql/
Note: Please reply to the newsgroups only unless you are interested in
consulting services. All other replies may be ignored :)
"Lost!" <Lost@.discussions.microsoft.com> wrote in message
news:272B4F05-D539-4F86-966B-EA74B23D7C20@.microsoft.com...
> I'm thinking this can't be done, but wanted to try it anyways...
> Is there any way a user can grant permission for another user to drop one
> of
> his/her tables? Something like this:
> GRANT DROP TABLE ON MYTABLE TO ALL;
> We have a table which can be created by a user then left alone for a while
> (data import procedure) which needs to be dropped by someone else (on the
> next import, the ID numbers need to be set back to one). Thanks in
> advance!sql
Friday, March 9, 2012
Drop database permissions
how can I deny drop database from "database creators" servr role?
You could try DENY ALTER DATABASE. I'm not sure, though...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> how can I deny drop database from "database creators" servr role?
|||Server: Msg 165, Level 16, State 1, Line 1
Privilege ALTER DATABASE may not be granted or revoked.
"Tibor Karaszi" wrote:
> You could try DENY ALTER DATABASE. I'm not sure, though...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
>
|||Hi Amit
I believe what you want to try is not possible
1) Changes cannot be made to Fixed Server Roles.
2) Once a user is granted Database Creator permissions, by default he
becomes the database owner. And the database owner cannot be denied the
rights to drop his database.
Regards
Amer M J
MCP
"Amit Eshet" wrote:
[vbcol=seagreen]
>
> Server: Msg 165, Level 16, State 1, Line 1
> Privilege ALTER DATABASE may not be granted or revoked.
>
> "Tibor Karaszi" wrote:
|||thanks,
but now the user can drop other databases to (am I wrong?)
"Amer M J" wrote:
[vbcol=seagreen]
> Hi Amit
> I believe what you want to try is not possible
> 1) Changes cannot be made to Fixed Server Roles.
> 2) Once a user is granted Database Creator permissions, by default he
> becomes the database owner. And the database owner cannot be denied the
> rights to drop his database.
> Regards
> Amer M J
> MCP
> "Amit Eshet" wrote:
|||Hi Amit
Yes, once the user has been added to the Database Creators group, he gains a
default right to drop databases and as i mentioned earlier tht changes are
not allowed to the fixed server roles.
"Amit Eshet" wrote:
[vbcol=seagreen]
> thanks,
> but now the user can drop other databases to (am I wrong?)
> "Amer M J" wrote:
You could try DENY ALTER DATABASE. I'm not sure, though...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> how can I deny drop database from "database creators" servr role?
|||Server: Msg 165, Level 16, State 1, Line 1
Privilege ALTER DATABASE may not be granted or revoked.
"Tibor Karaszi" wrote:
> You could try DENY ALTER DATABASE. I'm not sure, though...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
>
|||Hi Amit
I believe what you want to try is not possible
1) Changes cannot be made to Fixed Server Roles.
2) Once a user is granted Database Creator permissions, by default he
becomes the database owner. And the database owner cannot be denied the
rights to drop his database.
Regards
Amer M J
MCP
"Amit Eshet" wrote:
[vbcol=seagreen]
>
> Server: Msg 165, Level 16, State 1, Line 1
> Privilege ALTER DATABASE may not be granted or revoked.
>
> "Tibor Karaszi" wrote:
|||thanks,
but now the user can drop other databases to (am I wrong?)
"Amer M J" wrote:
[vbcol=seagreen]
> Hi Amit
> I believe what you want to try is not possible
> 1) Changes cannot be made to Fixed Server Roles.
> 2) Once a user is granted Database Creator permissions, by default he
> becomes the database owner. And the database owner cannot be denied the
> rights to drop his database.
> Regards
> Amer M J
> MCP
> "Amit Eshet" wrote:
|||Hi Amit
Yes, once the user has been added to the Database Creators group, he gains a
default right to drop databases and as i mentioned earlier tht changes are
not allowed to the fixed server roles.
"Amit Eshet" wrote:
[vbcol=seagreen]
> thanks,
> but now the user can drop other databases to (am I wrong?)
> "Amer M J" wrote:
Drop database permissions
how can I deny drop database from "database creators" servr role?You could try DENY ALTER DATABASE. I'm not sure, though...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> how can I deny drop database from "database creators" servr role?|||Server: Msg 165, Level 16, State 1, Line 1
Privilege ALTER DATABASE may not be granted or revoked.
"Tibor Karaszi" wrote:
> You could try DENY ALTER DATABASE. I'm not sure, though...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
>|||Hi Amit
I believe what you want to try is not possible
1) Changes cannot be made to Fixed Server Roles.
2) Once a user is granted Database Creator permissions, by default he
becomes the database owner. And the database owner cannot be denied the
rights to drop his database.
Regards
Amer M J
MCP
"Amit Eshet" wrote:
[vbcol=seagreen]
>
> Server: Msg 165, Level 16, State 1, Line 1
> Privilege ALTER DATABASE may not be granted or revoked.
>
> "Tibor Karaszi" wrote:
>|||thanks,
but now the user can drop other databases to (am I wrong?)
"Amer M J" wrote:
[vbcol=seagreen]
> Hi Amit
> I believe what you want to try is not possible
> 1) Changes cannot be made to Fixed Server Roles.
> 2) Once a user is granted Database Creator permissions, by default he
> becomes the database owner. And the database owner cannot be denied the
> rights to drop his database.
> Regards
> Amer M J
> MCP
> "Amit Eshet" wrote:
>|||Hi Amit
Yes, once the user has been added to the Database Creators group, he gains a
default right to drop databases and as i mentioned earlier tht changes are
not allowed to the fixed server roles.
"Amit Eshet" wrote:
[vbcol=seagreen]
> thanks,
> but now the user can drop other databases to (am I wrong?)
> "Amer M J" wrote:
>
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> how can I deny drop database from "database creators" servr role?|||Server: Msg 165, Level 16, State 1, Line 1
Privilege ALTER DATABASE may not be granted or revoked.
"Tibor Karaszi" wrote:
> You could try DENY ALTER DATABASE. I'm not sure, though...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
>|||Hi Amit
I believe what you want to try is not possible
1) Changes cannot be made to Fixed Server Roles.
2) Once a user is granted Database Creator permissions, by default he
becomes the database owner. And the database owner cannot be denied the
rights to drop his database.
Regards
Amer M J
MCP
"Amit Eshet" wrote:
[vbcol=seagreen]
>
> Server: Msg 165, Level 16, State 1, Line 1
> Privilege ALTER DATABASE may not be granted or revoked.
>
> "Tibor Karaszi" wrote:
>|||thanks,
but now the user can drop other databases to (am I wrong?)
"Amer M J" wrote:
[vbcol=seagreen]
> Hi Amit
> I believe what you want to try is not possible
> 1) Changes cannot be made to Fixed Server Roles.
> 2) Once a user is granted Database Creator permissions, by default he
> becomes the database owner. And the database owner cannot be denied the
> rights to drop his database.
> Regards
> Amer M J
> MCP
> "Amit Eshet" wrote:
>|||Hi Amit
Yes, once the user has been added to the Database Creators group, he gains a
default right to drop databases and as i mentioned earlier tht changes are
not allowed to the fixed server roles.
"Amit Eshet" wrote:
[vbcol=seagreen]
> thanks,
> but now the user can drop other databases to (am I wrong?)
> "Amer M J" wrote:
>
Drop database permissions
how can I deny drop database from "database creators" servr role?You could try DENY ALTER DATABASE. I'm not sure, though...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> how can I deny drop database from "database creators" servr role?|||Server: Msg 165, Level 16, State 1, Line 1
Privilege ALTER DATABASE may not be granted or revoked.
"Tibor Karaszi" wrote:
> You could try DENY ALTER DATABASE. I'm not sure, though...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> > how can I deny drop database from "database creators" servr role?
>|||Hi Amit
I believe what you want to try is not possible
1) Changes cannot be made to Fixed Server Roles.
2) Once a user is granted Database Creator permissions, by default he
becomes the database owner. And the database owner cannot be denied the
rights to drop his database.
Regards
Amer M J
MCP
"Amit Eshet" wrote:
>
> Server: Msg 165, Level 16, State 1, Line 1
> Privilege ALTER DATABASE may not be granted or revoked.
>
> "Tibor Karaszi" wrote:
> > You could try DENY ALTER DATABASE. I'm not sure, though...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> > Blog: http://solidqualitylearning.com/blogs/tibor/
> >
> >
> > "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> > news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> > > how can I deny drop database from "database creators" servr role?
> >
> >|||thanks,
but now the user can drop other databases to (am I wrong?)
"Amer M J" wrote:
> Hi Amit
> I believe what you want to try is not possible
> 1) Changes cannot be made to Fixed Server Roles.
> 2) Once a user is granted Database Creator permissions, by default he
> becomes the database owner. And the database owner cannot be denied the
> rights to drop his database.
> Regards
> Amer M J
> MCP
> "Amit Eshet" wrote:
> >
> >
> > Server: Msg 165, Level 16, State 1, Line 1
> > Privilege ALTER DATABASE may not be granted or revoked.
> >
> >
> > "Tibor Karaszi" wrote:
> >
> > > You could try DENY ALTER DATABASE. I'm not sure, though...
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > > Blog: http://solidqualitylearning.com/blogs/tibor/
> > >
> > >
> > > "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> > > news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> > > > how can I deny drop database from "database creators" servr role?
> > >
> > >|||Hi Amit
Yes, once the user has been added to the Database Creators group, he gains a
default right to drop databases and as i mentioned earlier tht changes are
not allowed to the fixed server roles.
"Amit Eshet" wrote:
> thanks,
> but now the user can drop other databases to (am I wrong?)
> "Amer M J" wrote:
> > Hi Amit
> >
> > I believe what you want to try is not possible
> >
> > 1) Changes cannot be made to Fixed Server Roles.
> > 2) Once a user is granted Database Creator permissions, by default he
> > becomes the database owner. And the database owner cannot be denied the
> > rights to drop his database.
> >
> > Regards
> > Amer M J
> > MCP
> >
> > "Amit Eshet" wrote:
> >
> > >
> > >
> > > Server: Msg 165, Level 16, State 1, Line 1
> > > Privilege ALTER DATABASE may not be granted or revoked.
> > >
> > >
> > > "Tibor Karaszi" wrote:
> > >
> > > > You could try DENY ALTER DATABASE. I'm not sure, though...
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > http://www.karaszi.com/sqlserver/default.asp
> > > > http://www.solidqualitylearning.com/
> > > > Blog: http://solidqualitylearning.com/blogs/tibor/
> > > >
> > > >
> > > > "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> > > > news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> > > > > how can I deny drop database from "database creators" servr role?
> > > >
> > > >
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> how can I deny drop database from "database creators" servr role?|||Server: Msg 165, Level 16, State 1, Line 1
Privilege ALTER DATABASE may not be granted or revoked.
"Tibor Karaszi" wrote:
> You could try DENY ALTER DATABASE. I'm not sure, though...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> > how can I deny drop database from "database creators" servr role?
>|||Hi Amit
I believe what you want to try is not possible
1) Changes cannot be made to Fixed Server Roles.
2) Once a user is granted Database Creator permissions, by default he
becomes the database owner. And the database owner cannot be denied the
rights to drop his database.
Regards
Amer M J
MCP
"Amit Eshet" wrote:
>
> Server: Msg 165, Level 16, State 1, Line 1
> Privilege ALTER DATABASE may not be granted or revoked.
>
> "Tibor Karaszi" wrote:
> > You could try DENY ALTER DATABASE. I'm not sure, though...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> > Blog: http://solidqualitylearning.com/blogs/tibor/
> >
> >
> > "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> > news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> > > how can I deny drop database from "database creators" servr role?
> >
> >|||thanks,
but now the user can drop other databases to (am I wrong?)
"Amer M J" wrote:
> Hi Amit
> I believe what you want to try is not possible
> 1) Changes cannot be made to Fixed Server Roles.
> 2) Once a user is granted Database Creator permissions, by default he
> becomes the database owner. And the database owner cannot be denied the
> rights to drop his database.
> Regards
> Amer M J
> MCP
> "Amit Eshet" wrote:
> >
> >
> > Server: Msg 165, Level 16, State 1, Line 1
> > Privilege ALTER DATABASE may not be granted or revoked.
> >
> >
> > "Tibor Karaszi" wrote:
> >
> > > You could try DENY ALTER DATABASE. I'm not sure, though...
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > > Blog: http://solidqualitylearning.com/blogs/tibor/
> > >
> > >
> > > "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> > > news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> > > > how can I deny drop database from "database creators" servr role?
> > >
> > >|||Hi Amit
Yes, once the user has been added to the Database Creators group, he gains a
default right to drop databases and as i mentioned earlier tht changes are
not allowed to the fixed server roles.
"Amit Eshet" wrote:
> thanks,
> but now the user can drop other databases to (am I wrong?)
> "Amer M J" wrote:
> > Hi Amit
> >
> > I believe what you want to try is not possible
> >
> > 1) Changes cannot be made to Fixed Server Roles.
> > 2) Once a user is granted Database Creator permissions, by default he
> > becomes the database owner. And the database owner cannot be denied the
> > rights to drop his database.
> >
> > Regards
> > Amer M J
> > MCP
> >
> > "Amit Eshet" wrote:
> >
> > >
> > >
> > > Server: Msg 165, Level 16, State 1, Line 1
> > > Privilege ALTER DATABASE may not be granted or revoked.
> > >
> > >
> > > "Tibor Karaszi" wrote:
> > >
> > > > You could try DENY ALTER DATABASE. I'm not sure, though...
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > http://www.karaszi.com/sqlserver/default.asp
> > > > http://www.solidqualitylearning.com/
> > > > Blog: http://solidqualitylearning.com/blogs/tibor/
> > > >
> > > >
> > > > "Amit Eshet" <Amit Eshet@.discussions.microsoft.com> wrote in message
> > > > news:CDA547DA-EE96-4B1D-8FB3-35AA9B48D920@.microsoft.com...
> > > > > how can I deny drop database from "database creators" servr role?
> > > >
> > > >
Tuesday, February 14, 2012
Drill Down Reports Permissions Problem
Hi,
I've successfully setup the reports server 2005, on Windows Server 2003, and
had the permissions for the specific users configured to enable access to
the report. When a user logs into the report server, they can access the
reports I've created and deployed.
The problem arises when they try to drill down to the next level of the
report. I've created a report that is a matrix/crosstab report in the report
builder and the user can see the default (top level) of it without a problem.
However, as soon as they click on a record to drill down and get details on
it, they get an rsAccessDenied error that DOMAIN\User does not have
permissions.
As a test, I gave a specific user full content-manager rights (essentially I
tried everything short of giving them local admin rights to the box) and they
still can't run the drill down.
I'm wondering if they need report builder installed to generate the drill
down on the fly? We are using IWA on the domain to access the report server
itself. I thought I had the permissions set up fine, since they can run the
report at first, and I haven't found any options to allow/disallow drill
downs.
Any suggestions to try would be much appreciated. Thanks in advance for the
help.
-PeteHello Pete,
I would like to know this issue more clearly.
1. Did you mean you create the report in the report builder?
2. Have you provided proper permission on the Report Model you use in the
report builder?
3. Did this issue appeared on all the report you developed in report
builder?
4. Have you applied the latest services pack of SQL Server?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Wei,
Thanks for the quick response. I'll answer your questions in-lin below, and
I appreciate any help you can give.
1. Did you mean you create the report in the report builder?
Yes, I created the data source, and data model using the report manager, and
then created the report using report builder. I did all of this as the local
admin on the box on which reporting services was running, and had no
permissions problems (as I was in the default group on RS). The user was on
an external WinXP bx, without report builder loaded when trying to access the
report. They were manually added in as a Content Manager User on Report
Server, at the top level (which I believe gives them rights to all the lower
levels like th report and model.)
2. Have you provided proper permission on the Report Model you use in the
report builder?
Yes, I did. They are a Content Manager role user at the top level. They
can see the model, as well as the top level of the report.
3. Did this issue appeared on all the report you developed in report
builder?
It only appeared in Cross-tab (matrix) reports that I created. Standard
reports that do not have drill down capabilities ran fine.
4. Have you applied the latest services pack of SQL Server?
No, I haven't. I don't believe they have been approved by internal IT
support yet, but I can check if necessary. Would you recommend I install
just SP1, or the additional hot fixes that are currently available after SP1
as well?
Thank you for the help. Please let me know if you need more information,
and I'd be happy to provide it.
-Pete
"Wei Lu [MSFT]" wrote:
> Hello Pete,
> I would like to know this issue more clearly.
> 1. Did you mean you create the report in the report builder?
> 2. Have you provided proper permission on the Report Model you use in the
> report builder?
> 3. Did this issue appeared on all the report you developed in report
> builder?
> 4. Have you applied the latest services pack of SQL Server?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Pete,
Thanks for the update.
First, please apply the SP1 for SQL 2005 and let me know the result.
Second, I would like to know whether you have grant the proper permission
on the datasource for the user.
That means, did the user have permission to access the datasource?
If the datasource is the sql server, did they have permission to access it?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei,
I checked the user account, and he does have permissions to the data source
- he is able to edit or modify it, and generate a new model if he wanted to.
As I mentioned, the SP1 has not been approved yet for deployment internally.
Is there a knowledge base article that shows how this solves the problem
perhaps that I can reference to attempt to push the addition of it through?
If not, are there any other options or thoughts? Thanks for the help - I
appreciate it. Please let me know if you need more information.
-Pete
"Wei Lu [MSFT]" wrote:
> Hello Pete,
> Thanks for the update.
> First, please apply the SP1 for SQL 2005 and let me know the result.
> Second, I would like to know whether you have grant the proper permission
> on the datasource for the user.
> That means, did the user have permission to access the datasource?
> If the datasource is the sql server, did they have permission to access it?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Pete,
There is no KB about this issue.
When I ask you to check the permission , I mean you need to check whether
the user could access the SQL Server, not whether he could modify the data
source file in the report manager.
Also, could you generate a sample report so that I may try to reproduce
this on my side?
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================.|||Wei,
Thanks for the information. The data source is created using credentials
stored on the report server, which can successfully access the database. We
have one user to access the DB, and don't impersonate the one making the
request.
As for a sample report, I'm not sure can provide that easily. Due to the
environment where this is deployed, we can't let out any data or reports. I
could potentially create a similar one, but that would be on a different
database (Northwind?) and reports server.
The steps to create one are pretty easy, since i am not using ANY advanced
configuration. It is built only with the web-based report builder, and
contains two tables, in a matrix, or cross-tab, report.
Thanks for the help - any other ideas you may have would be appreciated.
-Pete
"Wei Lu [MSFT]" wrote:
> Hello Pete,
> There is no KB about this issue.
> When I ask you to check the permission , I mean you need to check whether
> the user could access the SQL Server, not whether he could modify the data
> source file in the report manager.
> Also, could you generate a sample report so that I may try to reproduce
> this on my side?
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================.
>
>|||Hello Pete,
The reason why I need a sample report is that I need to know the model you
created and the report design.
So any simple report which could reproduce the issue may help me to
troubleshooting.
Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)
I've successfully setup the reports server 2005, on Windows Server 2003, and
had the permissions for the specific users configured to enable access to
the report. When a user logs into the report server, they can access the
reports I've created and deployed.
The problem arises when they try to drill down to the next level of the
report. I've created a report that is a matrix/crosstab report in the report
builder and the user can see the default (top level) of it without a problem.
However, as soon as they click on a record to drill down and get details on
it, they get an rsAccessDenied error that DOMAIN\User does not have
permissions.
As a test, I gave a specific user full content-manager rights (essentially I
tried everything short of giving them local admin rights to the box) and they
still can't run the drill down.
I'm wondering if they need report builder installed to generate the drill
down on the fly? We are using IWA on the domain to access the report server
itself. I thought I had the permissions set up fine, since they can run the
report at first, and I haven't found any options to allow/disallow drill
downs.
Any suggestions to try would be much appreciated. Thanks in advance for the
help.
-PeteHello Pete,
I would like to know this issue more clearly.
1. Did you mean you create the report in the report builder?
2. Have you provided proper permission on the Report Model you use in the
report builder?
3. Did this issue appeared on all the report you developed in report
builder?
4. Have you applied the latest services pack of SQL Server?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Wei,
Thanks for the quick response. I'll answer your questions in-lin below, and
I appreciate any help you can give.
1. Did you mean you create the report in the report builder?
Yes, I created the data source, and data model using the report manager, and
then created the report using report builder. I did all of this as the local
admin on the box on which reporting services was running, and had no
permissions problems (as I was in the default group on RS). The user was on
an external WinXP bx, without report builder loaded when trying to access the
report. They were manually added in as a Content Manager User on Report
Server, at the top level (which I believe gives them rights to all the lower
levels like th report and model.)
2. Have you provided proper permission on the Report Model you use in the
report builder?
Yes, I did. They are a Content Manager role user at the top level. They
can see the model, as well as the top level of the report.
3. Did this issue appeared on all the report you developed in report
builder?
It only appeared in Cross-tab (matrix) reports that I created. Standard
reports that do not have drill down capabilities ran fine.
4. Have you applied the latest services pack of SQL Server?
No, I haven't. I don't believe they have been approved by internal IT
support yet, but I can check if necessary. Would you recommend I install
just SP1, or the additional hot fixes that are currently available after SP1
as well?
Thank you for the help. Please let me know if you need more information,
and I'd be happy to provide it.
-Pete
"Wei Lu [MSFT]" wrote:
> Hello Pete,
> I would like to know this issue more clearly.
> 1. Did you mean you create the report in the report builder?
> 2. Have you provided proper permission on the Report Model you use in the
> report builder?
> 3. Did this issue appeared on all the report you developed in report
> builder?
> 4. Have you applied the latest services pack of SQL Server?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Pete,
Thanks for the update.
First, please apply the SP1 for SQL 2005 and let me know the result.
Second, I would like to know whether you have grant the proper permission
on the datasource for the user.
That means, did the user have permission to access the datasource?
If the datasource is the sql server, did they have permission to access it?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei,
I checked the user account, and he does have permissions to the data source
- he is able to edit or modify it, and generate a new model if he wanted to.
As I mentioned, the SP1 has not been approved yet for deployment internally.
Is there a knowledge base article that shows how this solves the problem
perhaps that I can reference to attempt to push the addition of it through?
If not, are there any other options or thoughts? Thanks for the help - I
appreciate it. Please let me know if you need more information.
-Pete
"Wei Lu [MSFT]" wrote:
> Hello Pete,
> Thanks for the update.
> First, please apply the SP1 for SQL 2005 and let me know the result.
> Second, I would like to know whether you have grant the proper permission
> on the datasource for the user.
> That means, did the user have permission to access the datasource?
> If the datasource is the sql server, did they have permission to access it?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Pete,
There is no KB about this issue.
When I ask you to check the permission , I mean you need to check whether
the user could access the SQL Server, not whether he could modify the data
source file in the report manager.
Also, could you generate a sample report so that I may try to reproduce
this on my side?
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================.|||Wei,
Thanks for the information. The data source is created using credentials
stored on the report server, which can successfully access the database. We
have one user to access the DB, and don't impersonate the one making the
request.
As for a sample report, I'm not sure can provide that easily. Due to the
environment where this is deployed, we can't let out any data or reports. I
could potentially create a similar one, but that would be on a different
database (Northwind?) and reports server.
The steps to create one are pretty easy, since i am not using ANY advanced
configuration. It is built only with the web-based report builder, and
contains two tables, in a matrix, or cross-tab, report.
Thanks for the help - any other ideas you may have would be appreciated.
-Pete
"Wei Lu [MSFT]" wrote:
> Hello Pete,
> There is no KB about this issue.
> When I ask you to check the permission , I mean you need to check whether
> the user could access the SQL Server, not whether he could modify the data
> source file in the report manager.
> Also, could you generate a sample report so that I may try to reproduce
> this on my side?
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================.
>
>|||Hello Pete,
The reason why I need a sample report is that I need to know the model you
created and the report design.
So any simple report which could reproduce the issue may help me to
troubleshooting.
Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Subscribe to:
Posts (Atom)