Can groups be set up within SQL Server 2000?

We would like to create groups (like Windows OS Groups) strictly within SQL
Server. This would give us easier control over permissions of groups SQL
Server login accounts. Then we wouldn't have to maintain permissions on
many, many individual SQL Server logins.
I realize that we could give the same users permissions through Windows
"Local Users and Groups", but our current goal is to not give them Windows
user accounts--just SQL Server permissions.
Any ideas?
Thanks!
JimYou cannot create groups at the server level but you can at the DB level.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Jim Moon" <please.reply@.group> wrote in message
news:uSBRYp8FGHA.3864@.tk2msftngp13.phx.gbl...
We would like to create groups (like Windows OS Groups) strictly within SQL
Server. This would give us easier control over permissions of groups SQL
Server login accounts. Then we wouldn't have to maintain permissions on
many, many individual SQL Server logins.
I realize that we could give the same users permissions through Windows
"Local Users and Groups", but our current goal is to not give them Windows
user accounts--just SQL Server permissions.
Any ideas?
Thanks!
Jim|||I see what you mean--create a role, add user(s) to that role, and assign
permission on database objects.
Thank you, Tom!
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ejpLPG9FGHA.2040@.TK2MSFTNGP14.phx.gbl...
> You cannot create groups at the server level but you can at the DB level.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Jim Moon" <please.reply@.group> wrote in message
> news:uSBRYp8FGHA.3864@.tk2msftngp13.phx.gbl...
> We would like to create groups (like Windows OS Groups) strictly within
> SQL
> Server. This would give us easier control over permissions of groups SQL
> Server login accounts. Then we wouldn't have to maintain permissions on
> many, many individual SQL Server logins.
> I realize that we could give the same users permissions through Windows
> "Local Users and Groups", but our current goal is to not give them Windows
> user accounts--just SQL Server permissions.
> Any ideas?
> Thanks!
> Jim
>
>|||As long as it's a database role, yes.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Jim Moon" <please.reply@.group> wrote in message
news:ezNEXM9FGHA.3080@.TK2MSFTNGP10.phx.gbl...
I see what you mean--create a role, add user(s) to that role, and assign
permission on database objects.
Thank you, Tom!
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ejpLPG9FGHA.2040@.TK2MSFTNGP14.phx.gbl...
> You cannot create groups at the server level but you can at the DB level.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Jim Moon" <please.reply@.group> wrote in message
> news:uSBRYp8FGHA.3864@.tk2msftngp13.phx.gbl...
> We would like to create groups (like Windows OS Groups) strictly within
> SQL
> Server. This would give us easier control over permissions of groups SQL
> Server login accounts. Then we wouldn't have to maintain permissions on
> many, many individual SQL Server logins.
> I realize that we could give the same users permissions through Windows
> "Local Users and Groups", but our current goal is to not give them Windows
> user accounts--just SQL Server permissions.
> Any ideas?
> Thanks!
> Jim
>
>

Can groups be driven by parameters

I have a simple report grouped by Quarter (with quarterly totals) and
then by Month (with monthly totals).
I would like to give the user the option to select the grouping they
would like to see. If they select a 'Monthly' parameter, is there a way
to ignore the quarterly group?
Currently:
Month,year col1_total col2_total
Month,year col1_total col2_total
Month,year col1_total col2_total
Quarter col1_total col2_total
Month,year col1_total col2_total
Month,year col1_total col2_total
Quarter col1_total col2_total
Report total col1_total col2_total
I would like to not show the "Quarter" line if they select Monthly.
Can this be done with parameters?Michael wrote:
> I have a simple report grouped by Quarter (with quarterly totals) and
> then by Month (with monthly totals).
> I would like to give the user the option to select the grouping they
> would like to see. If they select a 'Monthly' parameter, is there a
> way to ignore the quarterly group?
> Currently:
> Month,year col1_total col2_total
> Month,year col1_total col2_total
> Month,year col1_total col2_total
> Quarter col1_total col2_total
> Month,year col1_total col2_total
> Month,year col1_total col2_total
> Quarter col1_total col2_total
> Report total col1_total col2_total
> I would like to not show the "Quarter" line if they select Monthly.
> Can this be done with parameters?
You can use an expression on the visibility of the group and reference
your parameter. If the parameter equals 'Monthly', set the visibility
to false, else set the visibility to true.

Can Calculated Measures be in specific Measure Group?

I have two measure groups in my cube, and a calculated measure that only uses measures from one of the measure groups. Is there a way to assign that calc measure to one of my measure groups, so in client applications, users will find in in a logical place, rather than sitting all by itself where it might be confusing?

Thanks

Kory

Yes they can. The feature is well hidden away though:
In BIDS select your cube and the calculations tab. Then select the Cube-> Calculation Properties menu item.|||

Yes, certainly. In the Cube Editor in BIDS, go to the Calculations tab and click on the 'Calculation Properties' button on the toolbar (it's next to the buttons which switch between form view and script view). You can associate calculated measures with measure groups in the resulting dialog.

HTH,

Chris

Can a virtual server have local Windows users and groups?

Hi,
I have a scenario which works fine on a non-clustered SQL server, and I now
want to implement it on a clustered SQL server.
In a stand-alone, non-clustered environment:
- I have local Windows security groups on the machine; call the groups
MyGroup1, MyGroup2.
- I grant these groups login to the server, and access to the DB, as
follows: (later I add them to DB roles)
declare @.servername sysname
declare @.pos int
set @.servername = serverproperty('MachineName')
set @.pos = charindex(N'\', @.servername, 0)
if @.pos > 0
set @.servername = left(@.servername, @.pos-1)
use master
declare @.loginame sysname
set @.loginame = @.servername + '\MyGroup1'
if (not exists (select name from syslogins where name = @.loginame))
begin
exec sp_grantlogin @.loginame
end
exec sp_defaultdb @.loginame, MyDatabase
I'd like to do something similar on a clustered SQL server. But does a
cluster have a concept of local Windows groups, or must they be domain
groups?
How would I go about setting this up?
Thanks,
John.
I think I can answer this, since a cluster requires a domain account to
run - just make domain groups. Besides creating the local ones would be a
pain, think about failover.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"John [412075]" <John_dot_Knox_hyphen_Davies@.wonderware0com> wrote in
message news:OmdbtRLBFHA.3376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a scenario which works fine on a non-clustered SQL server, and I
> now
> want to implement it on a clustered SQL server.
> In a stand-alone, non-clustered environment:
> - I have local Windows security groups on the machine; call the groups
> MyGroup1, MyGroup2.
> - I grant these groups login to the server, and access to the DB, as
> follows: (later I add them to DB roles)
> declare @.servername sysname
> declare @.pos int
> set @.servername = serverproperty('MachineName')
> set @.pos = charindex(N'\', @.servername, 0)
> if @.pos > 0
> set @.servername = left(@.servername, @.pos-1)
> use master
> declare @.loginame sysname
> set @.loginame = @.servername + '\MyGroup1'
> if (not exists (select name from syslogins where name = @.loginame))
> begin
> exec sp_grantlogin @.loginame
> end
> exec sp_defaultdb @.loginame, MyDatabase
>
> I'd like to do something similar on a clustered SQL server. But does a
> cluster have a concept of local Windows groups, or must they be domain
> groups?
> How would I go about setting this up?
> Thanks,
> John.
>