The short answer is "You can't"

The longer answer discusses the risky username:password syntax and points out that its probably not a good idea to try to use it.

The only way the CGI could provide the user with access to the data would be to act as a proxy (fetching data from the site, rewriting links et al to pass through the CGI and then passing it on to the user)