A couple of quick questions about SQL Server 6.5

I have a couple of quick questions to do with SQL 6.5.
1. Is there a stored proc that I can use in conjunction with
sp_foreachtable to step though all the user tables and list the permissions
that the public role has.
2. When I use the generate SQL Script , to have it script up all the
logins,users and permissions. I then look at the resulting script and it seem
to set all the passwords to (Null). Is there a way to have the passwords
intact?Hi
1. I think you would need to look at writing your own that queries the
sysprotects/sysusers tables.
2. I believe this is by design. You may want to look at:
http://tinyurl.com/5yw77
John
"Russell" <Russell@.discussions.microsoft.com> wrote in message
news:515AAE7C-B95F-4573-BD41-1BFB037F84D1@.microsoft.com...
> I have a couple of quick questions to do with SQL 6.5.
> 1. Is there a stored proc that I can use in conjunction with
> sp_foreachtable to step though all the user tables and list the
permissions
> that the public role has.
> 2. When I use the generate SQL Script , to have it script up all the
> logins,users and permissions. I then look at the resulting script and it
seem
> to set all the passwords to (Null). Is there a way to have the passwords
> intact?|||> 1. I think you would need to look at writing your own that queries the
> sysprotects/sysusers tables.
Or perhaps sp_helprotect?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%230$dreinEHA.3152@.TK2MSFTNGP10.phx.gbl...
> Hi
> 1. I think you would need to look at writing your own that queries the
> sysprotects/sysusers tables.
> 2. I believe this is by design. You may want to look at:
> http://tinyurl.com/5yw77
> John
> "Russell" <Russell@.discussions.microsoft.com> wrote in message
> news:515AAE7C-B95F-4573-BD41-1BFB037F84D1@.microsoft.com...
>> I have a couple of quick questions to do with SQL 6.5.
>> 1. Is there a stored proc that I can use in conjunction with
>> sp_foreachtable to step though all the user tables and list the
> permissions
>> that the public role has.
>> 2. When I use the generate SQL Script , to have it script up all the
>> logins,users and permissions. I then look at the resulting script and it
> seem
>> to set all the passwords to (Null). Is there a way to have the passwords
>> intact?
>|||Hi Tibor
I didn't think that was in 6.5?
John
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OwymtcknEHA.3464@.tk2msftngp13.phx.gbl...
> > 1. I think you would need to look at writing your own that queries the
> > sysprotects/sysusers tables.
>
> Or perhaps sp_helprotect?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%230$dreinEHA.3152@.TK2MSFTNGP10.phx.gbl...
> > Hi
> >
> > 1. I think you would need to look at writing your own that queries the
> > sysprotects/sysusers tables.
> >
> > 2. I believe this is by design. You may want to look at:
> > http://tinyurl.com/5yw77
> >
> > John
> >
> > "Russell" <Russell@.discussions.microsoft.com> wrote in message
> > news:515AAE7C-B95F-4573-BD41-1BFB037F84D1@.microsoft.com...
> >> I have a couple of quick questions to do with SQL 6.5.
> >>
> >> 1. Is there a stored proc that I can use in conjunction with
> >> sp_foreachtable to step though all the user tables and list the
> > permissions
> >> that the public role has.
> >>
> >> 2. When I use the generate SQL Script , to have it script up all the
> >> logins,users and permissions. I then look at the resulting script and
it
> > seem
> >> to set all the passwords to (Null). Is there a way to have the
passwords
> >> intact?
> >
> >
>|||Hi John,
To be honest, I'm not 100% certain. But if I'd guess, I'd guess that the proc did exist in 6.5.
Due to a disk crash, I don't have my VM Ware images with 6.5 anymore, so I guess we'll wait until
someone with 6.5 or 6.5 BOL can tell us for certain. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ens2aOmnEHA.3392@.TK2MSFTNGP15.phx.gbl...
> Hi Tibor
> I didn't think that was in 6.5?
> John
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OwymtcknEHA.3464@.tk2msftngp13.phx.gbl...
>> > 1. I think you would need to look at writing your own that queries the
>> > sysprotects/sysusers tables.
>>
>> Or perhaps sp_helprotect?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:%230$dreinEHA.3152@.TK2MSFTNGP10.phx.gbl...
>> > Hi
>> >
>> > 1. I think you would need to look at writing your own that queries the
>> > sysprotects/sysusers tables.
>> >
>> > 2. I believe this is by design. You may want to look at:
>> > http://tinyurl.com/5yw77
>> >
>> > John
>> >
>> > "Russell" <Russell@.discussions.microsoft.com> wrote in message
>> > news:515AAE7C-B95F-4573-BD41-1BFB037F84D1@.microsoft.com...
>> >> I have a couple of quick questions to do with SQL 6.5.
>> >>
>> >> 1. Is there a stored proc that I can use in conjunction with
>> >> sp_foreachtable to step though all the user tables and list the
>> > permissions
>> >> that the public role has.
>> >>
>> >> 2. When I use the generate SQL Script , to have it script up all the
>> >> logins,users and permissions. I then look at the resulting script and
> it
>> > seem
>> >> to set all the passwords to (Null). Is there a way to have the
> passwords
>> >> intact?
>> >
>> >
>>
>|||sp_helprotect has been around since since the beginning.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%234k4pTmnEHA.3988@.tk2msftngp13.phx.gbl...
> Hi John,
> To be honest, I'm not 100% certain. But if I'd guess, I'd guess that the
> proc did exist in 6.5.
> Due to a disk crash, I don't have my VM Ware images with 6.5 anymore, so I
> guess we'll wait until someone with 6.5 or 6.5 BOL can tell us for
> certain. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:ens2aOmnEHA.3392@.TK2MSFTNGP15.phx.gbl...
>> Hi Tibor
>> I didn't think that was in 6.5?
>> John
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in
>> message news:OwymtcknEHA.3464@.tk2msftngp13.phx.gbl...
>> > 1. I think you would need to look at writing your own that queries the
>> > sysprotects/sysusers tables.
>>
>> Or perhaps sp_helprotect?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:%230$dreinEHA.3152@.TK2MSFTNGP10.phx.gbl...
>> > Hi
>> >
>> > 1. I think you would need to look at writing your own that queries the
>> > sysprotects/sysusers tables.
>> >
>> > 2. I believe this is by design. You may want to look at:
>> > http://tinyurl.com/5yw77
>> >
>> > John
>> >
>> > "Russell" <Russell@.discussions.microsoft.com> wrote in message
>> > news:515AAE7C-B95F-4573-BD41-1BFB037F84D1@.microsoft.com...
>> >> I have a couple of quick questions to do with SQL 6.5.
>> >>
>> >> 1. Is there a stored proc that I can use in conjunction with
>> >> sp_foreachtable to step though all the user tables and list the
>> > permissions
>> >> that the public role has.
>> >>
>> >> 2. When I use the generate SQL Script , to have it script up all the
>> >> logins,users and permissions. I then look at the resulting script and
>> it
>> > seem
>> >> to set all the passwords to (Null). Is there a way to have the
>> passwords
>> >> intact?
>> >
>> >
>>
>>
>