Friday, February 29, 2008

Who can log in during restricted session?

Couple of quick statements to identify potentially problem users during an upgrade or patch:

select grantee from dba_sys_privs where privilege = 'RESTRICTED SESSION'

Some of the results will be roles... for example, the dba role will be in that result set.

You'll need to track down who has the dba role as well:

select grantee from dba_role_privs where granted_role = 'DBA';

Saturday, February 16, 2008

AT&T SMTP issue

In an effort to cut down on spam, AT&T by default blocks pretty much all external smtp servers.

You can remove this block by submitting an abuse report here: http://helpme.att.net/servabuse.php

Choose Opt-out Port 25 from the abuse type list.

They recommend that mail hosts use an authenticated port 587 instead of 25, so you wouldn't need to worry about the port block.

(As for reaching work smtp from at&t? You can always use vpn, no?)

Telnet in windows vista?

Looks like the telnet client isn't installed by default with vista.

Try typing telnet from the command line. D'oh!

Fix? Start >> Control Panel >> Programs >> Turn Windows features on or off

Find Telnet Client in the client list, check the box to install and click OK.

Now from the command prompt, telnet works as expected.